topic Re: Current Week distinct date count in App Development

Current Week distinct date count

usamabinsadiq — Thu, 07 Apr 2022 08:02:36 GMT

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])

Re: Current Week distinct date count

usamabinsadiq — Thu, 07 Apr 2022 08:38:23 GMT

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])