Change Date Format

[Stephen Cairns]

I have a date being entered into a textbox in a dd/mm/yy format, however I need to be able to change this format to a yyyy/mm/dd in order to pass the date into a stored procedure and run some asp code. Does anyone know how to do this date format change in the background say on the onclick event of a button

[Bob Barrows]

Stephen Cairns wrote:

> I have a date being entered into a textbox in a dd/mm/yy format,
> however I need to be able to change this format to a yyyy/mm/dd in
> order to pass the date into a stored procedure and run some asp code.
> Does anyone know how to do this date format change in the background
> say on the onclick event of a button

[url]http://www.aspfaq.com/show.asp?id=2313[/url] vbscript
[url]http://www.aspfaq.com/show.asp?id=2040[/url] help with dates
[url]http://www.aspfaq.com/show.asp?id=2260[/url] dd/mm/yyy confusion

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[CJM]

Function ISODate(ByVal strDate)

Dim strFormat

strFormat = "%Y-%M-%D"
' Insert Padded Day of Month
strFormat = Replace(strFormat, "%D", Right("0" & DatePart("d", strDate),
2), 1, -1, vbBinaryCompare)

' Insert Padded Month Numbers
strFormat = Replace(strFormat, "%M", Right("0" & DatePart("m", strDate),
2), 1, -1, vbBinaryCompare)

' Insert Long Year (4 digit)
strFormat = Replace(strFormat, "%Y", DatePart("yyyy",strDate), 1, -1,
vbBinaryCompare)

ISODate = strFormat

End Function


Chris


"Stephen Cairns" <S.Cairns@belfasttelegraph.co.uk> wrote in message
news:C17D0C30-1BBE-446A-8A9E-D36FF73AB76E@microsoft.com...

> I have a date being entered into a textbox in a dd/mm/yy format, however I

need to be able to change this format to a yyyy/mm/dd in order to pass the
date into a stored procedure and run some asp code. Does anyone know how to
do this date format change in the background say on the onclick event of a
button

[Aaron Bertrand [MVP]]

>> yyyy/mm/dd in order to pass the date into a stored procedure

The only safe date-only format to pass to SQL Server is YYYYMMDD. Any other
format is vulnerable to ambiguous interpretation.