B bigmac Registered User. Local time Today, 03:14 Joined Oct 5, 2008 Messages 302 Jul 2, 2013 #1 hi all, can you help please, i need to check a field [date] against the current date, this i can do but what if i want it to check [date] against the current date minus 1 month? can you help please
hi all, can you help please, i need to check a field [date] against the current date, this i can do but what if i want it to check [date] against the current date minus 1 month? can you help please
spikepl Eledittingent Beliped Local time Today, 12:14 Joined Nov 3, 2010 Messages 6,142 Jul 2, 2013 #2 Then you use one of the date functions http://www.techonthenet.com/access/functions/