Add 1 Year to year part of date

[Kassy]

I have a query based on payment date which I have extracted the Year part as a seperate Field StartYear, but I want to now add EndYear which just adds 1 year to the StartDate. e.g. EndYear = StartYear +1. Anyone kow please I know i's proably simple but I keep getting syntax errors.

 

[Bat17]

endYear:year(startdate)+1 should work. If you want to add to the actual date then look up the DateAdd Function

Peter

 

[raskew]

Kassy -

Look up the DateAdd() function.

Bob

 

[Kassy]

Many thanks it works