format date 1

[gc1234]

Hi

Anyone know how i can use format with date function to return

23/3/2004 format?

 

[Chopstik]

Using the FormatDateTime() function, you could achieve this result if the regional settings are set to read the values as such. However, since you likely cannot provide that this will always be true, you could just create a sub that would return a string value as you would like. Something akin to the following might work (you need to change to your purposes, but the idea should be here:

myDate = 3/23/2004 'This can be whatever date you want.
returnDate = day(myDate) & "/" & month(myDate) & "/" & year(myDate)
response.write returnDate

-----------------------------------------------------------------------------------------------------
"If you can't explain something to a six-year-old, you really don't understand it yourself."
-- Albert Einstein

 

[gc1234]

Super thxs