Month to Date Formula 1

[plextor]

I really need help creating a date selection formula. I'm attempting to capture information for the current month. The report is ran daily to get information for the previous business day, and the rest of the month. For example: today's report will include the 1st to the 17th of August.

I tried to use the "MonthToDate" selection, but it fails to get the last day of the month.

Any help would be greatly appreciated.

Brian
CR 9.0 Professional

 

[bdreed35]

You can use something like this:

{table.date} in minimum(monthtodate) to currentdate


or this would work as well:

{table.date} in minimum(monthtodate) to maximum(monthtodate)+1

~Brian

 

[synapsevampire]

Try Report->Edit Selection Formula->Record:

{table.date} >= cdate(year(currentdate),month(currentdate),1)
and
{table.date} <= currentdate-1

-k

 

[bdreed35]

If you are looking for the whole month, try this instead:

{table.date} in minimum(monthtodate) to dateadd("m",1,minimum(monthtodate))-1

~Brian

 

[plextor]

Thank you, thank you!