Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys..
is there something wrong with my script? I'm not sure about the cal year
=[Cal. Month] >= Month(today())-1 and [Cal. Month] <=Month(today())-1 and [Cal. Year] = {'$(=year(today())-1)'}
this script i want to use in column filter
if normal
[Cal. Year] = '2023' or [Cal. Year] = '2022' and [Cal. Month] = 'Jul'
output like this
#filter
Do you have months and years in the same field?
Maybe you could give me an example of your field?
thanks for the response@JHuis
i have column on pivot table row fully expanded. column name cal. month.
so the output is like this
if to get a month can, using script =[Cal. Month] >= Month(today())-1 and [Cal. Month] <=Month(today())-1
but when you get cal. years can not, [Cal. Year] <=Year(today())
what I'm confused about, if you use a script like this the year it appears
the desired result is like this