topic Re: How to get Date format in Calculated dimension in QlikView

How to get Date format in Calculated dimension

Mon, 05 May 2014 13:27:04 GMT

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

Re: How to get Date format in Calculated dimension

Mon, 05 May 2014 13:31:01 GMT

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

Re: How to get Date format in Calculated dimension

ashfaq_haseeb — Mon, 05 May 2014 13:32:23 GMT

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

Re: How to get Date format in Calculated dimension

ZoeM — Tue, 26 Jan 2021 20:17:31 GMT

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.