format my string into a date!

[andycharger]

I have a string from a textbox (request.form("date"))
Now I want to format that into a date format.

Reason I ask is when im preparing it for my SQL statement im doing this:

strDate = "# " & request.form("date") & " #"

This gives me "# 01/02/2004/ #"
However, it has problems gewtting into SQL Server like this. It seems to want it like this:
# 01 / 02 / 2004 # and not all closed up.

How can I format my string so that SQL server will take it?

 

[andycharger]

Ignore the extra / Its a mistake!

I was trying to demonstrate the date all closed up!!!!

 

[Derek Stone]

Leave off the pound signs and format the date, as it appears you are doing, as "mm/dd/yyyy". Microsoft SQL Server does parse dates in the same fashion as Microsoft Access.

 

[andycharger]

Formatting

Ok, so if I want to format the request.form("date") string into a valid date style (i.e. dd/mm/yyyy).
so how would I do that?
Is it something like:

FormatDate(request.form("date")), dd/mm/yyyy)

 

[bungpeng]

You should convert the String to Date format first, before format it to dd/mm/yyyy:

Format(myDate, "dd/MM/yyyy")

 

[Derek Stone]

I wouldn't suggest either one of those solutions as they assume the date is in a particular format.

Try the solution I posted in this thread instead.