date plus 12 months

[agorman]

Hi,

Is there a formula I can use to put in a field (expires on) which will automatically generate a date in 12 months time - that is, sum of another another field (renewed on) plus 12 months?

Thanks

Adrian

 

[boblarson]

You don't need to store this (in fact that violates normalization rules) but you can display it anytime by using:

DateAdd("m", 12, [YourDateFieldNameHere])

 

[agorman]

Thanks for that Bob.


I have been trying to figure out how to run a query so I can see anyone who has a subscription that has expired. That is, all who have an expiry date before today's date. Is this something that ios too complex ? (I am a learner)

 

[boblarson]

You can create a field in the query by using:

ExpDate: DateAdd("m", 12, [YourDateFieldNameHere])

And then in the criteria use
< Date()

 

[agorman]

Thanks again Bob

Regards
Adrian