Date time format changes ?

I have an html page which has a date picker control. The format as displayed by the client is dd/mm/yyyy.

This date is then submitted to an asp page on the server. When i use

Code:

---

<%=request.item("datepicker")%>

---

the return value is in mm/dd/yyyy format.

I have checked the regional settings on the server, and the date is set to dd/mm/yyyy format.

So where is the change taking place?:confused:

You could 'force' an input date into a specific format. First use the isDate function in client-side validation to ensure a valid date is entered in the first place, then use formatDateTime in the ASP. In your case it'd be:

Code:

---

tempDate = formatDateTime(request.item("datepicker"))

---

This should output the date as MM/DD/YYYY (but look up the formatDateTime function to see the different numerical arguments if it doesn't - I can't quite remember).

You can then rearrange the MM and DD by doing something like:

Code:

---

arrDate = split(tempDate)

'Assign temp vars values from the array
tempMonth = arrDate(0)  'Month as First array element(0)
tempDay = arrDate(1)        'Day as Second array element(1)
tempYear = arrDate(2)        'Year as Third array element(2)

strDate = tempDay & tempMonth & tempYear

---

Hope that helps.

I have done something similar, but this does seems quite messy. Is there not another solution.

The question still stands. At what stage is the date being changed?

Doesn't the datepicker allow you to choose its format property (dataformat property or similar)? Or can you use Format(dd/mm/yyyy) on it or something?

Yes it does have a format property. But it is the same as the formatdatetime function of vbscript. Also, as i display the date in the client browser, the format is dd/mm/yyyy. So the control has the correct value. It seems through, that it is changing when I read it in from the request object on the server. If I response.write the value, I get mm/dd/yyyy format. I have checked the regional settings on the server and the format is definitley dd/mm/yyyy. So why does my format change when reading it in from the request object?