on 05-24-2010 9:19 AM
How to get last 30 days data in CR XI using Record selection formula??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rajesh
Use formula in the record selection and use function LastFullMonth to get last 30 days data
Thanks
Krishnan
There is also a built-in Aged0To30Days function. If it's specifically the last Month data you want, there is also a LastFullMonth function.
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
thk u
If my solution resolves your issue, then please do rate the answer as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.