Need help in expression

[#1]

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

[kaushiknsolanki · Accepted solution]

Hi,

     Try this.

     Count({<LastSignedDate = {">=$(=Date(Today()-60,'DD/MM/YYYY'))"}>}User_ID)

Regards,

Kaushik Solanki

[jagan]

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.

[mdmukramali]

Dear,

Kindly find the attachment.

Thanks,

Mukram.

[#5]

Thanks ...

It worked..