Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sunil,
Try like below
Count( {<RYear ={'$(=Year(Today()))'}, DateField = {"<=$(=Date(Today(),'YourDateFieldFormat'))"}>} Distinct LicenceNo )
Hi Mayil,
Its giving a zero as a result any other correction please.
Thanks
Sunil Kumar
Hi Sunil,
Can you please send the sample app?