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.
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.
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
