Need help on date format change

Closed
venkat - 28 Sep 2009 à 10:15
 Blocked Profile - 29 Sep 2009 à 07:46
Hello,

I need some help regarding date format,i need script for change date format from dd-mm-yyyy to mm/dd/yyyy

Thanks in advance.
Related:

2 responses

Funny, you have the same name as one of the experts on this forum and you are asking a very basic question :).

Right click on the cell, click on the 9th option from the top (cell properties/format cell). Go to the tab on the left side and select the option on the bottom of the list. Now you can input mm/dd/yyyy.

Best regards,
Trowa
Blocked Profile
29 Sep 2009 à 07:46
Dear Sir,

Please try using the two following scipts

<%
Response.write FormatDateTime(todaysDate,0)
%>

and

<%
Response.write FormatDateTime(todaysDate,1)
%>

Thanks.