Hi there,
I am making something with ASP and I need to capture the date of when a message is enterd and then sort all messages by date.

Problem is that I need the Dates to be dd/mm/yy. The dates are only formastted like that when the day is larger than 12..i.e. if its 16/05/01 then its alright.
But with 10 May 2001 I get
05/10/01

Please could soemone help me with how to get the date to format correctly. I have tried this...

private sub AccDate(myDate) 'date converter
theDate = Day(myDate) & "/" & Month(myDate) & "/" & Year(myDate)
end sub

the date is fine until it gets written to the access database and then it swaps to the wrong way around. My regional settings are set correctly.

Thanks in advance