Custom Report Date Filter

(0) Share

Report

Posted on by Community Member Microsoft Employee

I am trying to modify a date filter to default from Today: Begin Filter FieldName = "ViewTenders.Date" FilterOp = reportfilteropBetween FilterLoLim = "" FilterHilim = "" End Filter (displays current date) to Yesterday (a selection in the date picker dropdown): Begin Filter FieldName = "ViewTenders.Date" FilterOp = reportfilteropBetween FilterLoLim = "" FilterHilim = "" End Filter However, this places the text Yesterday in the date field and the report will not run (type mismatch error). I know that the keyword for This Month is MonthStart, does anyone know what the keyword for Yesterday? Thanks, Ted Archer CIO Fairvilla Megastore

*This post is locked for comments

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Custom Report Date Filter

Sorry, apparently text inside of quotes does not display. The values I was able to find are <YearStart>, <MonthStart> and <Today>. To use current month as the default for a report set the FilterHiLim to <MonthStart> and the FilterLoStart to <Today>.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Custom Report Date Filter

I was able to find the following are examples of valid values for the FilterLoLim and FilterHiLim properties in the Customization Guide and examining other reports: "" "" "". For Last Month you set the FilterHiLim to "" and FilterLoLim to "".
Community Member Microsoft Employee on at

Like (0)

Report

RE: Custom Report Date Filter

I've wondered the same thing about setting the default date filter on a report to Last Month. I tried using LastMonthStart and LastMonthEnd but it didn't work.