Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
i Have two fields User Id & Last Signed Date ,I need the count of User Id's who have signed in within last 60 days.need to write an expression for this
User Id Last Signed Date
1 11/11/13
2 12/10/13
3 04/10/13
4 05/04/13
5 06/02/13
The date format is (DD/MM/YYYY)
Thanks in advance
Hi,
Try this.
Count({<LastSignedDate = {">=$(=Date(Today()-60,'DD/MM/YYYY'))"}>}User_ID)
Regards,
Kaushik Solanki
Hi,
Try this.
Count({<LastSignedDate = {">=$(=Date(Today()-60,'DD/MM/YYYY'))"}>}User_ID)
Regards,
Kaushik Solanki
Hi Senthil,
Try this expression
=Count({<[Last Signed Date]= {">=$(=Date(Today()-60,'DD/MM/YYYY'))<=$(=Date(Today(), 'DD/MM/YYYY'))"}>}
[User Id])
If you want unique Users count then use this expression
=Count({<[Last Signed Date]= {">=$(=Date(Today()-60,'DD/MM/YYYY'))<=$(=Date(Today(), 'DD/MM/YYYY'))"}>}
DISTINCT [User Id])
Hope this helps you.
Regards,
Jagan.
Dear,
Kindly find the attachment.
Thanks,
Mukram.
Thanks ...
It worked..