Date filter - If Date is in a future month

[simon4amiee]

Hi guys, I cant seems to nail this one. I've two fields to work with:

[Date of Device]
[DischDate]

If i was explaining it, it would be as follows:

If [DischDate] Is in the next month after [Date of Device] then Y else N.

to add for example if the [Date of Device] is April 2015, and the [DischDate] is also April then i'd expect a N answer

to add for example if the [Date of Device] is April 2015, and the [DischDate] is May then i'd expect a Y answer

 

[Gasman]

Use the Month function and add 1. ?

Just be careful when the the [Date of Device] is December.

Probably best to create a function.?

 

[plog]

DateDiff function will do this for you:

http://www.techonthenet.com/access/functions/date/datediff.php