topic Re: Date formatting not working . Help ! in QlikView

Date formatting not working . Help !

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

After long time i was trying to format date_of_sale field . But i was unable to . Due to which it is not integrating with Master calendar .

Although I have tried Num , Date # combination as well . Need help .

Regards

Shekar

shekhar_analyti — Fri, 16 Jun 2017 16:38:05 GMT

I THINK I DID IT .. THANKS

sunny_talwar — Fri, 16 Jun 2017 16:38:07 GMT

Try this

Date(Date#(Date_of_sale,'D/M/YYYY')) AS DS,

shekhar_analyti — Fri, 16 Jun 2017 16:40:57 GMT

This worked for me too ;

Date#(Text(Date_of_sale),'DD/MM/YYYY')

sunny_talwar — Fri, 16 Jun 2017 16:45:53 GMT

Don't really need Text() as it is already a text