In my analysis filter I need a range over three month exactly.
With this formular I get the last day of the preceding month:
ADD_DAYS(ROUND_MONTH(TODAY()), -1)
Today: 07.06.2021
Result: 31.05.2021
This is the secound part of the BETWEEN order.
Now I'm searching for the first formular in the BETWEEN order
sImilar to VBA: DateSerial(YEAR(Date()),MONTH(Date())-3,1)
Is there a chance?
Best answer by georg.sonde
I was searching and playing around and finally found the solution:
ROUND_MONTH(ADD_DAYS(TODAY(), -90))
Today: 14.06.2021
Result: 01.03.2021
maybe this helps somone else . . .
I was searching and playing around and finally found the solution:
ROUND_MONTH(ADD_DAYS(TODAY(), -90))
Today: 14.06.2021
Result: 01.03.2021
maybe this helps somone else . . .
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
