Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to set a 'Y' or a 'N' flag on a date dimension for a date range from 15 days ago through yesterday. I think I'm close, but I am having trouble with the syntax:
=if([Worker.HireDate]= '>=$(=date#(Today()-15)) <=$(=date#(Today()-1))','Y','N')
I've also tried =if([Worker.HireDate]= '>=$(=date(Today()-15,'YYYY-MM-DD')) <=$(=date(Today()-1,'YYYY-MM-DD'))','Y','N')
I appreciate any suggestions to resolve the issue!
Scott
Try this
IF([Worker.HireDate]>=(today()-15) AND [Worker.HireDate]<=(today()-1) , 'Y','N')
Try this
IF([Worker.HireDate]>=(today()-15) AND [Worker.HireDate]<=(today()-1) , 'Y','N')
Yes, that worked! Thank you soooo much for your help!
Scott