Date formatting with SQL

[MetroToday]

I am trying to pass a date value with a string onto the next page with ASP. However I cannot get the date format to work properly. I recall that one needs to include # signs in it. Can someone please take a look at my code below and help me out.



If Len(trim(frmSearch.StartDate.Value)) > 0 Then
WhereSTR = WhereSTR & "((Wire.Value)=" & frmSearch.StartDate.Value & &quot)" & WhereConc
End If

 

[HowardMarks]

Try the following:

If Len(trim(frmSearch.StartDate.Value)) > 0 Then
WhereSTR = WhereSTR & "((Wire.Value)=#" & frmSearch.StartDate.Value & "#))" & WhereConc
End If

I think this should work Nick (Software Developer)

http://www.retrographics.co.uk

http://www.retrotest.co.uk

nick@retrographics.fsnet.co.uk
nick.price@myenable.com