>>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.
If it's not broken, fix it until it is.
My Blog