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?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.