>>>Hi everybody,
>>>
>>>I am wondering how can I display datetime value using
>>>
>>>mm/dd/yyyy hh:mm:ss format where hours are in 24 format? Using transform(datetime()) returns date with AM/PM settings. Also, I may want to display it just up to hh:mm (no seconds).
>>
>>I recommend not doing that at all. I never offer that to clients due to the ambiguity of not knowing whether they're looking at mm/dd or dd/mm.
>>
>>Instead I give them something like 22-May, 22May, May-22 or May22. Three letters for the month is always distinct i.e. Mar/May, Jun/Jul etc. I think there are standard 2 letter month abbreviations if you're so inclined.
>
>We actually have preferences defined for the date, so if they want mm/dd/yyyy, this is what we will provide.
Well, you could offer new preferences :) I bet if you offer them any of those new preferences they would choose them instead.
Ambiguity costs money - that's why STRICTDATE was invented. If after looking at better options they still absolutely, positively want mm/dd then of course you give them that. But you look good offering them better options, and pointing out why mm/dd is suboptimal.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up