Filter data management export on date range

(0) Share

Report

Posted on by Hossam Z. EL Hassan

Hi,

I would like to like to create three data management export jobs with date criteria to include all records with accounting date less 15 days with relative days of -7 days from current date.

My current scenario is export a large number of records into three files as below.

records with accounting date 15 days less than today. This one is DayRange(-15,0). example : 11-JUL to 25-Jul

records with accounting date 15 days less than 15 days than today. I need help with this. example. 27-Jun to 10-Jul

records with accounting date 15 days less than 30 days than today. I need help with this. example. 13-Jun to 26 Jun

I have the same question (0)

All responses (4)

Answers (2)

Suggested answer

Gaurangkumar Jani 4,554 User Group Leader on at

Like (0)

Report
Copy link

Link copied!
Hi Hossam,

Try the following filters:

for records with accounting date 15 days less than 15 days than today. I need help with this. example. 27-Jun to 10-Jul

DayRange(-30,-15)

records with accounting date 15 days less than 30 days than today. I need help with this. example. 13-Jun to 26 Jun

DayRange(-45,-15)

Let us know if this helps you.

Thanks,

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Hossam,

For case no 2 and 3 just add 15 / 30 days on top of your Day Range Filter that you use for your first case.

Just increase the first and second number and things should work.

On this site you can find additional examples how you can filter data

docs.microsoft.com/.../advanced-filtering-query-options

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

huijij 19,811 on at

Like (1)

Report
Copy link

Link copied!

Hi Hossam,

As Mentioned,The DayRange() is to find a range of dates relative to the session date. Positive values indicate future dates, and negative values indicate past dates.

regards

Was this reply helpful? Yes No
Hossam Z. EL Hassan 22 on at

Like (1)

Report
Copy link

Link copied!

Thanks it works.

Was this reply helpful? Yes No