INSERTing Dates correctly prior to 1899
Posted on 2005-02-28
There seems to be a hidden intelligenence working against me:)
I have 3 DropDownLists for users to select Day, Month and Year the values ofthese are passed to a string var tmpValue
tmpValue = "#" & tmpDay & "/" & tmpMonth & "/" & tmpYear & "#"
strSQL = "UPDATE Births SET [Date]= " & tmpDate & " WHERE BirthID = " & Session("WorkingRecord")
If tmpValue is "04/01/1997" the date is correctly updated and disaplyed as 4th January 1997
If tmpValue is "04/01/1897" the date is incorrectly updated and disaplyed as 1st April 1897
I am assuming this is a vb,net problem as it is running alongside classic asp without any problems.
Any suggestions as to how I can kill off this little gremlin?