How to change dates in report automatically.

[Pallavi16]

I want to create a report with condition related to date and i want the date change to happen automatically and i will get the report through schedule job(via mail).

Could anyone help on this how i can achieve automatic change of dates.

[palanikumar]

Hi,

Date filters has option to select dynamic value. Eg, today, yesterday, last 7days etc. You can use them to make your report dynamic. Refer image below

You can use Scheduled Reports to send the report via email. 

[Pallavi16]

My request is, for example i have date between 1 to 7th Jan and next week it should automatically change from 8th to 14th.

[palanikumar]

You can try Last week on date condition. This will always take value from previous week. A week is between Monday to Sunday. Suppose Monday is 1st of the Month then weeks are 1-7, 8-14, 15-21, 22-28 etc. When you pull the report from 8th to 14th of month it will always retrieve 1-7. On 15th, it pulls from 8-14.

[Pallavi16]

I got what you are saying but i do have the custom range for example, below are the condition in report and it should change automatically on next weekend that is 28th to 31st