Need help on date format change

Closed
venkat - Sep 28, 2009 at 10:15 AM
 Blocked Profile - Sep 29, 2009 at 07:46 AM
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.

2 replies

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
0
Blocked Profile
Sep 29, 2009 at 07:46 AM
Dear Sir,

Please try using the two following scipts

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

and

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

Thanks.
0