• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 397
  • Last Modified:

getting data for the last 30 days

I need to add a formula on my report that retrieves data only for the last 30 days basing the current date as the starting point.

Can someone please show me how this can be achieved?

Thank you much.
1 Solution
Try something like

{YourDateField} >= CurrentDate - 30

If there are future dates in the field

{YourDateField} >= CurrentDate - 30
{YourDateField} <= CurrentDate

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now