VBScript - General - Question - DateFormat

[danasegarane]

Hi all
I am having a Date as
01-09-2008".(mm-dd-yyyy")
Now I am passing this date to WeekDay Function. This Function is not formating that to Regional settings . This format it as "dd-mm-yyyy". How to format the Date to the WeekDay Function with respect to regional settings of the client

[shweta123]

Hi,

You can use Format functon from vbscript in order to change the date format of given date.
e.g.

<%
Dim date1

''''Use Format function for converting date to dd-mm-yyyy format
date1= Format("01-09-2008","dd-mm-yyyy")
Response.write(date1)

%>

Hi all
I am having a Date as
01-09-2008".(mm-dd-yyyy")
Now I am passing this date to WeekDay Function. This Function is not formating that to Regional settings . This format it as "dd-mm-yyyy". How to format the Date to the WeekDay Function with respect to regional settings of the client

[jhardman]

Although this "should" work, sometimes making it work is difficult. The best solution I have found (which always works) is to always store and display the date in a non-ambiguous format such as "2008-Sep-12". Even though it isn't the standard, this format is never confused.

Jared