Fining the difference in the month.

[Locopete99]

Hi Guys,

Is there a way I can make a query for the following:

Criteria
Month([end date]) - Month([Today])=3

 

[Isskint]

Not too sure what you are asking here.

Do you want a query to return records where the difference between [EndDate] and today is 3 months? if so the DateDiff() function should help with this.

 

[Locopete99]

thanks I'll give that a try

 

[JMichaelM]

Maybe something like this:

Months: DateDiff("m",[DateFieldName],[End Date])

Change "m" to "d" for days
Put +1 or -1 at end for day adjustment of calculation