Current Week distinct date count

[usamabinsadiq]

can anyone help me out?

I am using the following statement and I want the count of the current week's dates, but I am getting 0, I don't see any syntax or logical error, please help me to resolve this.

Count({$<[RECON.Date] = {'>=$(=Date(WeekStart(Max([RECON.Date]), 0, 0))),<=$(=Date(WeekEnd(Max([RECON.Date]), 0, 0)))'}>} distinct [RECON.Date])

[usamabinsadiq · Accepted solution]

The 0 was showing due to a single quote changing it to double quote resolved it, also I removed , from between because of , it was treating it as 2 separate data sets and showing more result then expected.

Count({$<[RECON.Date] = {">=$(=Date(WeekStart(Max([RECON.Date]), 0, 0)))<=$(=Date(WeekEnd(Max([RECON.Date]), 0, 0)))"}>} distinct [RECON.Date])