I am trying to create a data range for my analysis.
I have the below equation which works:
FILTER “CASES”.“NetDueDate” BETWEEN ADD_DAYS(TODAY(),-6) AND TODAY() ;
However, i would like to replace the 2nd ‘TODAY’ with ‘the last day of the prior month’ - 6.
Can you please let me know if this can be achieved in Celonis?