Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get Date format in Calculated dimension

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:

5-05-2014 3-22-44 PM.png

results:

5-05-2014 3-23-06 PM.png

Thanks in advance, Leandro

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

3 Replies
Not applicable
Author

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

View solution in original post

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
Creator III
Creator III

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.