current month count

[sunil-kumar5]

Hello All,

I need to get the count of current year however we have some future dated records as well so I just want it to fix as today, can anyone please help. What condition I can use in my below expression.

Count( {<RYear ={'$(=Year(Today()))'}>} Distinct LicenceNo )

Thanks

[MayilVahanan]

Hi Sunil,

Try like below

Count( {<RYear ={'$(=Year(Today()))'}, DateField = {"<=$(=Date(Today(),'YourDateFieldFormat'))"}>} Distinct LicenceNo )

[sunil-kumar5]

Hi Mayil,

Its giving a zero as a result any other correction please.

Thanks

Sunil Kumar

[MayilVahanan]

Hi Sunil,

Can you please send the sample app?