How to get Date format in Calculated dimension

[#1]

Hi,

I'm having difficulties to get the calculated dimensions as Date format  (mm.yy). The natural results is number.

I would like to know how to Text format to be in the date format.

here it is the details of the issue:

Calculated dimension:

results:

Thanks in advance, Leandro

[#2 · Accepted solution]

use Date(DateFormated,'MMM/YY') in your calculated dimension

[ashfaq_haseeb]

Hi

try below

=date(date#(Datefield),'DD/MM/YYYY'),'MMM/YY')

Note:

make sure to 'DD/MM/YYYY' replace with your date time stamp.

hope it help.

Regards

ASHFAQ

[ZoeM]

I was dumb founded as to why my calculated field was not behaving the way I needed it to! Thanks, I had to stack a Date and Date# function together to get the formatting I needed.