Date Range Record Selection 4

[NattyCat]

Crystal V9, SQL Server 7.


I think my brain is leaking, as I simply cannot get it to function and create (what I think is) a simple formula.

Can anyone give me a quick solution while I see if some caffiene kicks my grey matter into gear?

I have a report that is scheduled to run on the 23rd of each month. The report needs to be limited to only show data from the 21st of the previous month to the 22nd of the current month - without parameters.


Help?

 

[Madawc]

If you can be sure of it being the 23rd, then From could be (DateAdd("m", -1, currentdate)-2 and To ould be currentdate-1

Madawc Williams (East Anglia, UK)

 

[lupins46]

{mytable.mydate} in DateTime (year(currentdate), month(currentdate)-1, 21, 00, 00, 00) to DateTime (year(currentdate), month(currentDate), 22, 00, 00, 00)

You might need to amend the time elements depending on the exact range that you want to include