Set queries and query filters for daily report and schedule it

[Former Member]

HI,

I have to schedule a daily report with all needed data which will be changing accordingly to the day and schedule it to the specific bench of people. As a schedule is not an issue itself, than the report is. We have data for a lot of dates planed ahead, however I need to set a report which will be collecting only one day for ex 05.11.2020 00:00:00 till 05.11.2020 23:59:59 and sent at 6:00am the same day (those data will be sent to the people which will be provided in the scheduler). Report needs to be send every day with current data day. If I will set query filter as sent "planned day" between 05.11.2020 00:00 - 05.11.23:59 every single day it will be sending the same data from the day which I have choose and set but I need to have updated data per day. Data at 6th of Nov from 06.11.2020 00:00 - 06.11.2020 23:59. Is it possible to set it and how ? I will appreciate for advice as I'm tired to change dates every day to have the report send in 6am as requested.

Regards

Gosia

[mynynachau]

Thank you for visiting SAP Community to get answers to your questions. Since you're new in asking questions here, check out our tutorial about asking and answering questions https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question now by selecting Actions, then Edit.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS . By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards

Your SAP Community moderator

[neilos]

Hi Gosia,

This is a query you constructed yourself?
If so, how is the date set in the query?

[Former Member]

Hi Neil,

Thanks for replying. I have set this query myself. In the object I have choose what I would like to have in my report (including things started from day) and in filter query I have set Day "Between" 2020-11-06 00:00:00:00 and 2020-11-06 23:59:59 with filter type "constant". I know this is not correct as it will be sending report only with the specific day which I have set (in this case 6.11.2020) but I have no clue how to set filter queries with prompt type of filter to send report in current day with data from the current day. Scheduled every day and every day data with new day should be sent.

Thanks