Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The below expression is working properly.
=if(([EMP_JOIN_DATE]>=Today()-10 AND [EMP_JOIN_DATE]<=Today()),1,0) ==> Working
But, when i use the variable it will not be recognize. Any syntax issue...?
=if(([EMP_JOIN_DATE]>=$(=vCalDate10) AND [EMP_JOIN_DATE]<=$(=vToday)),1,0) ==> Not working
=if([EMP_JOIN_DATE]>='$(vCalDate10)' AND [EMP_JOIN_DATE]<='$(vToday)',1,0)
whith variables :