I am trying to create a component filter for "the running past 24 months". - I can get a "since 2022" to work, but I can't get a floating filter, like "for the past two years" to work.Can you help me with the general syntax?Thank you.
Best answer by stephanie.parra
Hi,
for the past 24 months simply use ADD_MONTHS(TODAY(),-24) in the comparison, i.e.
FILTER Table.Date >= ADD_MONTHS(TODAY(),-24)
BR
Stephanie
+14Hi @karl.guent,
Very good question, I never tried this but I got something working.
FILTER YEAR ("ACTIVITIES_TABLE_PO"."EVENT_TIME") => (YEAR(TODAY()) - 2);
Let me know if this works on your end. Please validate the results 😁
EDIT: I think it should be => rather than >, I changed this.
Kind regards,
Sverre Klein
Hi,
for the past 24 months simply use ADD_MONTHS(TODAY(),-24) in the comparison, i.e.
FILTER Table.Date >= ADD_MONTHS(TODAY(),-24)
BR
Stephanie
Wow! These are both awesome!
- Stephanie ... The "TODAY -24 is truly elegant.
- Sverre ... the From => To approach is the way I was also thinking.
+14Hi,
for the past 24 months simply use ADD_MONTHS(TODAY(),-24) in the comparison, i.e.
FILTER Table.Date >= ADD_MONTHS(TODAY(),-24)
BR
Stephanie
Very nice, thanks Stephanie! 😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.