Using if statement for a date range syntax

[salleninsd]

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

[Vegar · Accepted solution]

Try this

IF([Worker.HireDate]>=(today()-15) AND  [Worker.HireDate]<=(today()-1) , 'Y','N')

[salleninsd]

Yes, that worked!  Thank you soooo much for your help!

Scott