Adding one year on to date field (1 Viewer)

[tb5038]

Hi this should be simple!

I want to add one year onto a date, I could do this in a query or just add it on on a textbox in the form?

Field Name is IncidentDate from table tbl_incidents

I know its so simple, new to this!

 

[Galaxiom]

Check out the DateAdd() function.

 

[tb5038]

Check out the DateAdd() function.

Thanks for the reply... I knew about the DateAdd Function I just dont know how to use it. This is my efford in a query...

Expiry: DateAdd("yyyy",1,[IncidentDate])

thanks

 

[Galaxiom]

Should work. What result did you get?

 

[tb5038]

Should work. What result did you get?

Thats great.... all sorted thanks for the suggestion

TJ