Hi Team,
Given the following..
{sql}
update jobtickets
set JobStatus = 'CL', DatePaid = CURENT_DATE
where jobstatus = 'RP' and dateout is not null and dateinvoiced is not null and daterepaired is not null and datepaid is null
{sql}
In edbmgr it keeps erroring saying that "The column CURENT_DATE does not exist in the table JobTickets)"
Huh?  I knew that..
Why isn't CURRENT_DATE valid?  The Help says it is..

Regards & TIA,
Ian

I should add that the field DatePaid is a Date field.

OK.  Inter digital Interface error.  Commonly known as Finger Fault.
It seems I can't spell.  CURENT_DATE is NOT the same thing as CURRENT_DATE.
All sorted.