View Full Version : DateDiff


Christine5017
03-07-2002, 06:58 AM
I have brain fog this morning, I have this query where I need to know if a Billed Date is 30 days old. I know that I have to do datediff but I have running to problems. Can someone please help me. Thank you so very much.

Jack Cowley
03-07-2002, 07:06 AM
<=Date()-30 in the criteria line of your billing date will show dates older than 30 days from today.

Christine5017
03-07-2002, 07:20 AM
Thank you so very much for your help. http://www.access-programmers.co.uk/ubb/smile.gif