Answered

How to automatically set date filter on a monthly basis

(0) Share

Report

Posted on by julian1994acuna

Hello,

I am working on a report extraction project. And I need to download those reports on a monthly basis. How do I set the date filters by month based on the current date. I will usually download the reports for the previous month and do this every first of the current month.

Sample Flow:

1. Login to Portal

2. Set the Start and End Date filter

3. Download Report

Thanks in Advance

Categories:

Power Automate Desktop

All responses (5)

Answers (1)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Can you enter text into those fields? If so:

see my article here. Not a sales pitch, just need to get two date is text format:

%BDLM_ddMMyyyy_slash% (beginning day last month)

%EDLM_ddMMyyyy_slash% (ending day last month)

once you have those:

populate text field on web page
Verified answer

Riyaz_riz11 4,219 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

You can try this way.

if works marks as solution it will helps for others
Regards,
Riyaz
julian1994acuna 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Riyaz,

Thank you for answering. May I ask what is the logic behind this solution as I'm pretty new in automation?

Please correct me If I'm wrong. So basically whenever you run this flow it will capture the current date and time. And it will be deducted by 30 days for the start date?

Thanks and Regards,
Julian
Riyaz_riz11 4,219 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

So here you can populate the field by using that variable.
Riyaz8850 2 on at

Like
a
(0)

Report
Copy link

Link copied!

in odoo platform if i click on date it opens a calander so what can i do?
i want to automate odoo to take 2 days before orders while running every time