Class function on date

[punitpopli]

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

Punit

[beskqlik]

by using the expression, can we get only last 90 days dates and split on based on that dates