Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Time display
Message
From
22/05/2013 16:01:02
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01574527
Message ID:
01574538
Views:
45
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform