Set Analysis Date Range

[usamashahid]

I'm trying to get count of employees who joined during specific dates. I've created date variables vStartDate and vEndDate. what ever I enter in the dates the count always shows zero. Please help, what am i doing wrong here.

Count({<STARTDATE = {">=$(vStartDate)<=$(vEndDate)"}>}EMPLID)

[sunny_talwar · Accepted solution]

May be try one of these

1) Count({<STARTDATE = {">=$(=vStartDate)<=$(=vEndDate)"}>}EMPLID)

2) Count({<STARTDATE = {">=$(=$(vStartDate))<=$(=$(vEndDate))"}>}EMPLID)

[usamashahid]

Thank you Sunny for the response.

Unfortunately, both didn't work. I really can't figure out why it is not working.

[sunny_talwar]

Would you be able to share a sample where this is not working?