write date into file in YYYY.MM.DD format

[Lars Schouw]

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

 

[Ron de Bruin]

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)

 

[Lars Schouw]

Thanks Ron,

=TEXT(TODAY(),"yyyy.mm.dd")

seems to do the stunt..

I need this format since some application have depends on it.. I agree
ISO format is much nicer,

 

[Ron de Bruin]

Look out if you also use Non English systems if you use the Text function

yyyy in the Netherlands is jjjj

English language Version entry:
="Today is "&TEXT(TODAY(),"yyyy-mm-dd")

In English language version the formula returns:
Today is 2005-02-23

Fails when the when workbook is open in Dutch language version (year = jaar "jjjj-mm-dd").
With a Dutch language version the formula will return:
Today is yyyy-02-23

 

[Lars Schouw]

Thanks I sometimes have users on Japanese systems.
Is there a nice workaround for that problem ?
Lars

 

[Ron de Bruin]

Hi Lars

If you do it with VBA it is always working correct

Sub test()
ActiveCell.Value = Format(Date, "yyyy.mm.dd")
End Sub

But not with the worksheetfunction



--

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


Thanks I sometimes have users on Japanese systems.
Is there a nice workaround for that problem ?
Lars