Problem statement-How to Filter date based on last 30 days , 60 days and 90 days from current date using Report Definition.
Solution- we can use filter the records based on last 30 days , 60 days and 90 days. we do not need to put condition like start date and end date, using only one condition it will work and filter the records. limitation of this approach is that , this is specific to only the 30 ,60 or 90 days not for specific days.
Example- filter records based on creation date from last 30 days can be used like below
There is no clear statement of intent in this Discussion.
Are you needing some help with your report definition and asking a question which requires an answer?
Or are you wanting to share a particular tip for which no documentation exists?
Do users not already have access to documentation for the use of these date functions and operators?
As forum moderators we try to make sure that our PSC content is clear and self-explanatory. As such I must admit that I struggled to see the aim of your discussion.
I’d like to therefore ask that you update the content to clearly define the purpose and audience if what you wrote is a Developer Knowledge Share.
Characteristics of an effective Developer Share Discussions:
Targeted. Each entry should be about one topic and should have a clear and descriptive title.
User-focused. Write about what your specific audiences ask for and may need help with.
Well-written. Double-check your grammar and adopt a friendly, conversational style to make it easier for customers to digest information.
Structured. Your article should have a clear beginning, middle, and end.
Illustrative. Whenever you can add your real-life example, graphics.
Comprehensive. Include all critical information as well as nice-to-knows that will make things easier for our users.
Discoverable. Use the right keywords and tags so users can easily discover your discussion.
Interactive. Give users the opportunity to provide feedback, either by asking them at the end of the discussion.
I would like to ask you to therefore modify your Discussion, or let me know if this needs to be converted into a Question post which you will need to pad out significantly in order for users to understand the issue.
The function which you have listed in your screenshot is something which is already available in the public domain, therefore I do not feel it adds any benefit to be published.
The functions are documented that if you want to show shows data from period “greater than 30 days” you can always Set Relationship to Less Than and Value to “LAST 30 DAYS” . This will get all records that have a last activity that is greater than 30 days ago. If you want all that have Activity IN the last 30 days, simply change the equality to Equals.
I do not believe this requires a Developer Knowledge Share as it stands.
Can you let me know once you have modified the post? I will unpublish it by the end of the week if we have no further response.
Thank you and please let us know if you have any questions!
