8 Replies Latest reply: Dec 29, 2014 4:12 PM by Enrique Colomer RSS

    Class function on date

    Punit Popli

      Hi All,


      I am having a requirement to group date in the group of 4 (for e.g.), I am achieving this using class function as : Class(Date,4,'x').

      But the calculated dimension giving the result in numbers as 41920<=x<41924 (highlighted with purple in screen shot below). Can we convert the result in numbers to Date?

      Attached is the sample spreadsheet for your reference.

      Thanks in advance