DateDiff

[Christine5017]

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]

<=Date()-30 in the criteria line of your billing date will show dates older than 30 days from today.

 

[Christine5017]

Thank you so very much for your help.