Date formats...

[Phailak]

Hail,

Here's my problem.
I'm retrieving a date from a text file that is in the following format:

MM/DD/YY

and need to make it into:

YYYY-MM-DD

I do the following:

Format("07/01/01", "yyyy-mm-dd&quot and get 2007-01-01

How can I correct this, is my format not correct?

Phailak

 

[Terpsfan]

This revised format should work:
Format(#07/01/01#, "yyyy-mm-dd&quot should provide you with the data format you need.

Chuck

 

[Phailak]

Hail,

Thanx, although I finally bypassed it by taking first 6 chrs, then adding "20" and then last 2 chrs. Works fine, your way would of saved me a detour though

Phailak