i want to update my fieldname realdate (from datatype "date") with the actual date of my
computer, but only the lines in my table where the other fieldname finaldate is older then
the actual date of my computer.

i tried this, but it dont work:

update orders set realdate = now where finaldate < now

orders is the name of my data-table

tom_po

update orders set realdate = current_date where finaldate < current_date

Roy Lambert

Roy Lambert <roy.lambert@skynet.co.uk> wrote:

tom_po

update orders set realdate = current_date where finaldate < current_date

Roy Lambert

thanks Roy