update query to add one day

[davidcantor]

I am running an update query to add one day to a date field and I get type conversion error.

Code: Select all

UPDATE AmountsInfo SET AmountsInfo.[IDATE] = DateAdd("d",1,[TDate]), AmountsInfo.TDate = "";

The update query should add one day to the Tdate and store that in the Idate field then clear the Tdate field.

[davidcantor]

fixed this by adding null instead of ""

[HansV]

That was quick!

[Rudi]

I guess there was nothing (null) to fix