Does anyone know how to get the last year relative...
# general
l
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
there are a bunch of relative year related filters
l
This one is for Results column. I need a column that always show the Year last year relative to today.
b
TO_NUMBER(TO_CHAR({today}, 'YYYY'))
should of done it
you should also be able to use EXTRACT