J
jason
I'm tearing out my hair here: ACCESS 2000:
When I attempt to overwrite a date in my date field with a new user selected
valid date eg: 05/23/99
my date field changes to the TIME I updated the field
and does not display my desired date: 05/23/99
Instead it reads: 12:12:03 AM
I am going nuts - even considering converting the field to text. The field
is a SHORT DATE
Here is my sql statement:
ChangeDate = request.form.item("ChangeDate") '// 05/23/76
UpdateSQL = "UPDATE tblListingspriceChanges SET NewPrice =" & NewPrice & ",
ChangeDate =" & ChangeDate & " WHERE PriceChangeID =" & PriceChangeID
'Response.end cnn.Execute(UpdateSQL)
Here is the result:
UPDATE tblListingspriceChanges SET NewPrice =20002, ChangeDate =05/23/76
WHERE PriceChangeID =28
Here is what ChangeDate Field looks like in Access:
12:04:07 AM
- I have even tried Cdate(ChangeDate) but this appears to make no
difference.
- Jason
When I attempt to overwrite a date in my date field with a new user selected
valid date eg: 05/23/99
my date field changes to the TIME I updated the field
and does not display my desired date: 05/23/99
Instead it reads: 12:12:03 AM
I am going nuts - even considering converting the field to text. The field
is a SHORT DATE
Here is my sql statement:
ChangeDate = request.form.item("ChangeDate") '// 05/23/76
UpdateSQL = "UPDATE tblListingspriceChanges SET NewPrice =" & NewPrice & ",
ChangeDate =" & ChangeDate & " WHERE PriceChangeID =" & PriceChangeID
'Response.end cnn.Execute(UpdateSQL)
Here is the result:
UPDATE tblListingspriceChanges SET NewPrice =20002, ChangeDate =05/23/76
WHERE PriceChangeID =28
Here is what ChangeDate Field looks like in Access:
12:04:07 AM
- I have even tried Cdate(ChangeDate) but this appears to make no
difference.
- Jason