Setting a Date field to Add a year

LewisTioga

How can I Take a date field and add a year too it. Take this code as an example of what I'm trying to achieve.


IF xRec."Product Group Code" <> 'COSHH' THEN
IF "Product Group Code" = 'COSHH' THEN
"Coshh Review Date" := WORKDATE + 365D;

RockWithNAV

Yes you need to use CALCDATE

https://msdn.microsoft.com/en-us/library/dd301368.aspx

Kishorm

"Coshh Review Date" := CALCDATE('<+1Y>',WORKDATE)

RockWithNAV

Yes you need to use CALCDATE

https://msdn.microsoft.com/en-us/library/dd301368.aspx