date manipulation champ 1

[onressy]

hi potential "Date Manipulation Champ",

i have time stamp in this format: MM/DD/YYYY

Trying to format it like this: YYYY-MM-DD

Having no luck:

varDate = "8/30/2006"

Replace(varDate, inStr(Left(varDate "/", 2)&"/"), Right(varDate, 4)&"-")


Any suggestions?

 

[ChrisHirst]

new_date = year(varDate) & "/" & month(varDate) & "/" & day(varDate)

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[onressy]

Thanks "Date Manipulation Champ" Chris