Less Then Today's Date

[NathanBa]

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.

[SunilDe]

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.

[MartyGa]

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