How to reformat the Date-Time string (e.g. 05/28/09 11:00:00)?
Been searching through help docs and trying substring manipulations, but getting nowhere, so asking this kind forum for assistance.
The "Time" field in a form generates values that are formatted like this:
05/28/09 11:00:00
When building a Dashboard, I don't want the trailing "seconds" to show in the time, so I've tried several things:
- looking for a preferences setting that would change the default time format -- None exists that I can find
- searching Help Docs for a code statement that allows formatting of the time -- None exists that I can find
- writing a substring manipulation that trims off the last 3 characters of the date-time string -- Can't make it work
Can anyone kindly assist me in getting control of the output of the date-time string, specifically to eliminate the trailing colon and seconds characters?
Many thanks in advance.
Greg
datazen1@gmail.com
Santa Fe, New Mexico US