Hi Guys,
This is probably a simple syntax issue for me but I am struggling to find an answer.
I am querying a table which contains 3000+ records which include a date field with an expiry date.
I would like an expression to filter expired dates including Null values and all records with an expiry date due up to and including the end of the following month.
I have had some success using the following:
The problem is I have to keep manually changing the value in the
section (39 in the example) in order to get the number of days from today up to the end of the following month. I have tried using
but it does not include all records up to the end of the month.
Is there an expression that will give me all records up to the end of the following month automatically regardless of when I run the query?
Any help gratefully received
This is probably a simple syntax issue for me but I am struggling to find an answer.
I am querying a table which contains 3000+ records which include a date field with an expiry date.
I would like an expression to filter expired dates including Null values and all records with an expiry date due up to and including the end of the following month.
I have had some success using the following:
Code:
Between DateAdd("m",-24,Date()) And DateAdd("d",39,Date()) Or Is Null
Code:
DateAdd("d",39,Date()
Code:
DateAdd("m",+1,Date()
Is there an expression that will give me all records up to the end of the following month automatically regardless of when I run the query?
Any help gratefully received