Suggestion for MS: Add 'Tomorrow' to list of dates for reports

Jan 20, 2006 2 Replies
T

I would absolutely *love* to be able to easily generate a work order report where the Due Date was 'Tomorrow'. Unfortunately, 'Tomorrow' isn't on the list and I have to change both From and To dates to tomorrows date in order to get the report.



Another thing would be for the memorized reports to focus on the Range field and not the From & To fields for date-type filters. If the Range is 'Last Month' and I run the report in January, I get December data. When I go to run the report in February, the report has memorized the December dates--now a 'Custom' Range--and not the 'Last Month' criteria I am looking for.



Tom


Vote
Twitter Facebook LinkedIn
J

TT,

There is a recent KB about creating a "Yesterday". Change the logic to add a day instead of subtracting it.

formatting link
When you memorize a report, it keeps the specific dates in the report file. Easy enough to change. Go into the Reports folder, right click on the memorized report, edit. Go the Filter section and change the FilterLoLim and the FilterHiLim from the dates to;

That's all I can remember right now. Someone posted the list, I think on this ng within the last couple of weeks

Vote
Twitter Facebook LinkedIn
T

I was able to make that work. For future reference, the KB article number is

911179.

Two things: In Step 4-- Replace the "SelCriteria =" line with the following. SelCriteria = "convert(varchar(10),(Getdate()-1),101) convert(varchar(10),[Transaction].Time,101)"

First, change the Getdate()-1 to +1 (you want tomorrow, not yesterday). You'll also need to make sure that the [Transaction].Time field is the same as the Field Name in the Filter portion of the report. In my case, I had to change it to [Order].ExpirationOrDueDate.

I still think that 'Tomorrow' should be a valid Range, especially for reports that deal with open WOs and POs.

Tom

"Jeff" wrote:

formatting link

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required