Discussion Board for collaboration related to QlikView App Development.
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:
Thanks in advance, Leandro
use Date(DateFormated,'MMM/YY') in your calculated dimension
View solution in original post
make sure to 'DD/MM/YYYY' replace with your date time stamp.
hope it help.
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.