Field Format: Combining standard date/time formats

[Guest]

I need to format a date field in manner which combines the "Short Date" and
"Short Time" formats. In the U.S. it would look like "1/19/06 18:43".

Does anyone know of a way to accomplish this relatively easily?

Things I already know:
The "General Date" format appears to use "Short Date" and "Medium Time".
But, I want to avoid the use of AM/PM if at all possible, since my users are
used to working in the 24hr time format.

I know I can use a Custom Format string, but the application is used
globally, so I need it to use the appropriate "Short" formats based upon the
user's regional settings.

Any help would be greatly appreciated.

 

[Douglas J. Steele]

AFAIK, the only option is a custom format.

If you're really concerned, you could detect the user's settings when the
application is started up, and then reset the custom format everywhere, but
that sounds a bit excessive to me.