Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateTime Format
I need to know the available formats for date and time.
I am interested in the Data ss:Type='DateTime'. This type show my dates in the YYYY-MM-DDTHH:MM:SS.000 format. Is there anyone who can tell me what to use to show my dates as MM/DD/YYYY HH:MM AM ???? I can bring up the Command and Options window and change it in Excel, but I want to show it this way when I create it. Thanks for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateTime Format
defaults are set thru control panel/regional settings. to be indepent of user settings you'll have to format your date yourself ? format(now,"mm/dd/yy hh:mm AM/PM") more info: VBA help on: User-Defined Date/Time Formats (Format Function) keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Joe Harriman" wrote: I need to know the available formats for date and time. I am interested in the Data ss:Type='DateTime'. This type show my dates in the YYYY-MM-DDTHH:MM:SS.000 format. Is there anyone who can tell me what to use to show my dates as MM/DD/YYYY HH:MM AM ???? I can bring up the Command and Options window and change it in Excel, but I want to show it this way when I create it. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Datetime CSV format | Excel Discussion (Misc queries) | |||
Remove Time from DateTime | Excel Discussion (Misc queries) | |||
datetime format issues when linking access to excel | Excel Discussion (Misc queries) | |||
autodate and datetime stamp | Excel Worksheet Functions | |||
datetime in query | Excel Programming |