date range in header 1

[INTP]

I have a monthly report, and I want the header to automatically display the date range for the month of the data in the report.

I tried inserting the DataDate finction from the Document Properties in the formula editor... but it displays todays date rather than the date of the data that I'm using.

 

[lbass]

If you have limited your report to one month, and if the date field cannot be null, then the following formula should work:

totext({table.date}-day({table.date})+1,"MM/dd/yyyy") + " to " +
totext(dateadd("m",1,{table.date}-day({table.date})+1)-1,"MM/dd/yyyy")

-LB

 

[INTP]

Yes, thank you. That did work. Now, just out of curiosity, if I were to change it to a annual, quarterly, weekly or daily report? What would I need to change to get the date to display?

 

[lbass]

Yearly:
totext(date(year({table.date}),1,1),"MM/dd/yyyy") + " to " +
totext(date(year({table.date}),12,31),"MM/dd/yyyy")

Quarterly:
totext(dateserial(year({table.date}), (datepart("q",{table.date})*3)-2,1),"MM/dd/yyyy") + " to " +
totext(dateserial(year({table.date}), (datepart("q",{table.date})*3)+1,1)-1,"MM/dd/yyyy")

Weekly:
totext({table.date}-dayofweek({table.date})+1, "MM/dd/yyyy") + " to " +
totext({table.date}-dayofweek({table.date})+7, "MM/dd/yyyy")

Daily:
{table.date}

-LB

 

[INTP]

Thanks!