2 of 2 people found this helpful
This seems to simple based on the formula you've already been able to create, but doesn't changing the -12 in your dateadd to -24 do it?
Or do you actually want to see months -24 to -13? In which case this might do it:
IF DATETRUNC('month',[YYYYMM Date]) >= DATETRUNC('month',DATEADD('month',-24,[Auths Thru])) AND DATETRUNC('month',[YYYYMM Date]) < DATETRUNC('month',DATEADD('month',-12,[Auths Thru]))
1 of 1 people found this helpful
Hey Andrew Watson,
Thanks for your help, that was very immediate, in fact I have corrected my previous Rolling 12 month logic too as per your logic, I have tested it, works fine.
Thanks, can you mark the answer as correct to get this thread closed?
I cannot see any actions to mark the answer as correct.. can you help me on that..
Actually I'm not sure - I don't often post questions on here :-) Maybe it's one of the Actions?