How can I create a formula for April 2017 and one for April 2016 (without using filters)?
1 answer
I'm not sure what you mean by not using filters, but this formula will only have a value if it is within one of those two ranges, and NULL if another.
if datetrunc('month',[Date]) = '2017-04-01' or datetrunc('month',[Date]) = '2016-04-01' then [Date]
end
