Does anyone know how to get the last year relative to today on a saved search?
I tried TO_CHAR({today},'YYYY') to get this year. I was trying to convert this to a number so I can subtract 1. I tried TO_NUMBER and CAST. None of which works.
b
battk
11/04/2020, 1:45 AM
there are a bunch of relative year related filters
l
Luis
11/04/2020, 1:47 AM
This one is for Results column. I need a column that always show the Year last year relative to today.