How to "Update" a Date field 2

[byrne1]

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?

 

[mirtheil]

You should use:
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

 

[byrne1]

Yep. That did the trick. Thanks!

 

[mirtheil]

No problem. Thanks for the star.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com