3 Replies Latest reply on Sep 26, 2013 4:49 PM by Andres Ustariz

    Is there any way to have a date value presented as a number. Something similar so as to when (in Excel) by changing the cell format category from Date to General (2/28/2013 presented as 41333)

    Andres Ustariz

      Just wondering if there is any option to have a date value presented as a number.

      My final goal is to aggregate (SUM) a measure by month and then come up with a daily average based on the calendar days of every month. The problem is that my data is not calendar driven, so I have gaps impeding to either row_count by month or use min - max for the dates.

      Any other suggestions are welcomed.

       

      temp.png