Date/Time filter in scheduled reports Cognos Impromptu 7.4 1

[thierryverstraete]

Dear community,

I would like to request your help with Cognos Impromptu 7.4 scheduled reports.

A client asked me to create a filter that would show a list of data between e.g. 11PM last night and 7AM this morning. I know how to do this with regular prompts but need some guidance on how to automate this for a scheduled report.

Thanks so much!

 

[drlex]

Thierry,
Whether it's a limitation of Impromptu or my database, I've never found the time handling functions to be useful; there being no add-hours or add-minutes capabilty.

If the report is being run daily, and there is no need to take account of weekends/public holidays, could you not use a filter like

(Datetimefield >= add-days (datetime-to-date( now()), -1) and hour (Datetimefield) >= 23 or ( Datetimefield >=datetime-to-date( now()) and hour(Datetimefield) < 7)

where datetimefield is the data to test, and now() function returns the current date and time? (Data that is at 7:00a.m. today will not be included - one would need to check the minutes too if hour=7 is tested).

HTH,
lex


soi la, soi carré

 

[thierryverstraete]

drlex,

Thank you for this reply. I will attempt this filter option.