1 Reply Latest reply on Mar 5, 2016 3:36 AM by Tharashasank Davuluru

    How to pad dates till today's date?

    Imtiyaz Jariwala

      Hi,

       

      I have a data source that have some recent dates data missing in the table. I am creating a dashboard to indicate missing date status as red and available as green color. When I pull a date from table, it lists all dates which are in the table (obviously!). I want to pad the date field to show dates which are not in table, that way I would be able to show the status for missing data.

       

      Example, available dates in table are 2/1 to 2/20 and today's date is 2/25, then date column should display all dates from 2/1 to 2/25.

       

      Any hint?