Adding Date

[finberg]

Is trying to run a code for Set in a field Expiry Date the date that is 3 month bigger that the one in shipement date.Has made a code:
Forms!insurance![Expiry date] = DateAdd("mm", 3, Forms!insurance![Date of Loading])
That does not work
Any ideas?

 

[TonyJollans]

Hi finberg,

Assuming it's not a typo in the post, try it with a single m instead of a double mm ..

Forms!insurance![Expiry date] = DateAdd("m", 3, Forms!insurance![Date of Loading])


Enjoy,
Tony