>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.
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