Date selection

[#1]

Hi experts

I have the following statement selectin values that are within the last month:

resident mitarbeiter where datum > Date(AddMonths(Today(),-1)) group by marnr;

I would like to have a statement where I only include values within the last 3 days.

Can someone help me with this?

Thanks

Jan

[MarcoWedel · Accepted solution]

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

[#3]

Hi Jan,

You can try the condition datum >= date(today(),-3).

Or upload the sample document.