I have MYData as Date,NewDate as Date
Mydata=dateNow eg. 21/05/2010
How to format NewDate in 2010-05-21 (yyyy-mm-dd)
Convert date
-
HansV
- Administrator
- Posts: 79324
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Convert date
The format is only the way the date is displayed. Internally, the date is stored the same way, whether it is displayed as 21/05/2010 or as 05/21/10 or as 2010-05-21 or as 21 maggio 2010.
Best wishes,
Hans
Hans