Specific date query

[mounty76]

Hi All,

I'm trying to write a query that returns the below:

Between (24th of the last month) And (27th of the current month)

Is straight forward for the first and last days of the month but am struggling with the specific dates?

Any help much appreciated!

Cheers

 

[mounty76]

Sorry folks, managed to figure it out

Between DateSerial(Year(Date()),Month(Date())-1,24) And DateSerial(Year(Date()),Month(Date()),27)

 

[Gasman]

Perhaps mark it solved then?

 

[plog]

Would that solution have worked a week ago? Need to use DateAdd to future proof it.

 

[pbaldy]

Would that solution have worked a week ago? Need to use DateAdd to future proof it.

Looks like yes:

?DateSerial(Year(#1/26/22#),Month(#1/26/22#)-1,24)
12/24/2021

 

[plog]

Apologies. It does work without having to manually account for the year change backwards.