Thread: write date into file in YYYY.MM.DD format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default write date into file in YYYY.MM.DD format
Hi Lars

Why not use the ISO format
http://www.rondebruin.nl/isodate.htm

1. Dates must be represented in either:
a. non-separated form of yyyymmdd (eg 20050330 for 30-Mar-2005)
b. separated form of yyyy-mm-dd (eg 2005-03-30 for 30-Mar-2005)



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Lars Schouw" wrote in message ...
From VBA I want to write a date into a file a file in the format
YYYY.MM.DD
how can I do this?


Lars
Reply With QuoteReply With Quote