Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a dashboard with 7 cells to show the data by hour for each of the previous 7 days. I want to show the date for the data that is being displayed in each cell. The expression that I am using does display the correct date but it also shows an error message along with the date. Below is the expression and a picture of what the cell looks like. I would also like to show the date in the mm/dd/yyyy format rather than how it is currently being displayed in the cell. Any help would be appreciated.
=Date={"$(=Date(Today()-7,'DD/MM/YYYY'))"}
my be
='Date=' & Date(Today()-7,'DD/MM/YYYY')
Thanks for the help. This does display the correct date but it is showing in the below format. How would I eliminate the "Date =" portion and display just the date?
Just use this Date(Today()-7,'DD/MM/YYYY')
That did it. Thank you.
Then please mark the thread as answered and help to close this thread