Less Then Today's Date | Community
Skip to main content
Level 2
July 6, 2016
Question

Less Then Today's Date

  • July 6, 2016
  • 2 replies
  • 713 views
What is the code that is used to represent "today's date" I want a report to change the color of the date to red if the date is falls before the day the report is ran. At this time I am just entering in the current date to make this happen.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Level 3
July 6, 2016
I trying to create a Matrix Hour Report. My rows are Users and the column is Entry Date (in months). The report looks okay but I would like it to sort by Total Hours i.e. I would like to sort it by user with highest number of hours to the lowest.
Level 4
July 8, 2016
code for "Today's Date" is $$TODAY Other parameters you may find useful are $$USER.name (substitutes the user id of the person who running the report) (can also substitute other USER attributes, such as role, id, etc. For a filter on "day before", you can use between $$TODAY - 1d and $$TODAY