Adding a number to a date

[Courtman]

Another logbook query.

I have two fields, one which shows my medical date, and the other which shows how many months my medical is valid for. I want this to create a result which says when my medical will expire.

For example:

Medical 21/11/01, valid for 60 months.

The validity needs to be in months because the older you get, the lesser the period (down to 6 months) the medical is valid for.

 

[anke]

hi again,

DateAdd("m",[valid_for],[Medical]) AS valid_until
should do it, check DateAdd in the help if u need more, it'll explain it better than me

anke