Aug 17, 2003 #1 pho01 Programmer Mar 17, 2003 218 US How do you change the date and time format to 'yyyy-mm-dd hh:mm:ss'? For example, if you run: Today = Now It would give you: '08/14/2003 7:30 PM' I want it to be showed: '2003-08-14 7:30:00' What function would it change the time format? Thanks!
How do you change the date and time format to 'yyyy-mm-dd hh:mm:ss'? For example, if you run: Today = Now It would give you: '08/14/2003 7:30 PM' I want it to be showed: '2003-08-14 7:30:00' What function would it change the time format? Thanks!
Aug 17, 2003 #2 BeginnerD Programmer Dec 30, 2002 4 MY Format(Now, "yyyy-mm-dd hh:mm:ss" Upvote 0 Downvote
Aug 18, 2003 Thread starter #3 pho01 Programmer Mar 17, 2003 218 US Thanks, that helped! Upvote 0 Downvote