on 05-24-2010 9:19 AM
How to get last 30 days data in CR XI using Record selection formula??
Rajesh
Use formula in the record selection and use function LastFullMonth to get last 30 days data
Thanks
Krishnan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is also a built-in Aged0To30Days function. If it's specifically the last Month data you want, there is also a LastFullMonth function.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Very easy... Datadate can be used to get the current date in CR XI. Use the condition as datefield <= datadate and datefield >= (datadate -30).
Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.