How to "Update" a Date field
How to "Update" a Date field
(OP)
I try to run an update at the control center to update a date field in a table using the sql statement "update custrel set dtndateofbirth=2/8/67 where customernum=80194565" but I gat the following error message:
"Incompatible types in column assignment list"
I've tried different formats for the date field including "yyyy/mm/dd", "yyyy-mm-dd", "mm-dd-yy" but none have worked.
What am I doing wrong?
"Incompatible types in column assignment list"
I've tried different formats for the date field including "yyyy/mm/dd", "yyyy-mm-dd", "mm-dd-yy" but none have worked.
What am I doing wrong?
RE: How to "Update" a Date field
update custrel set dtndateofbirth='1967-02-08' where customernum=80194565"
THe format is:
'yyyy-mm-dd'
The Single quotes are critical.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: How to "Update" a Date field
RE: How to "Update" a Date field
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com