Scripting time frame

[#1]

Hi Experts

I have the following script giving me all values within the last 35 days:

resident mitarbeiter where datum > Today()-35 group by marnr;

How can I read out all values within the last 35 days excluding the last 7 days.

Date > Today()-35 and Date < Today()-7

Thank you for your help!

Jan

[#2 · Accepted solution]

Hi,

For first resident take last 35 days, then resident it agn and remove last 7 days.

HTH

Regards,

Amay

[#3]

Works. Thank you.