date range ??

[PQTIII]

I want to set up a report to run from the first date of the month to the day before the current date. What is the formula that represents the first day of the current month?

Thanks
pt
Cr9

 

[oneilltnc]

not sure if your are trying to get the first of the month based upon the current date or from an actual field from within your report, but this should give you what you are looking for.

--Will get you the first of the month based upon the current date

DateTime (Year(CurrentDate()), Month(CurrentDate()), 01)

--Will get the the first of the month from a date field in your report.

DateTime (Year({YourFieldHere}), Month({YourFieldHere}), 01)

 

[lbass]

Use a record selection formula like:

{table.date} in date(year({currentdate}), month(currentdate),1) to currentdate-1

-LB