topic Re: Date Conversion in QlikView

Date Conversion

YADAVSLN — Mon, 14 Jan 2019 10:48:39 GMT

Hi All,

I have date like :2018-01-10

it's convert into like:DD-MMM-YYYY format

ex:10-01-2018

In script level and UI level please let me know.thanks.

Frank_Hartmann — Mon, 14 Jan 2019 10:51:40 GMT

try this:
Date(Date#(YOURDATEFIELD,'YYYY-MM-DD'),'DD-MM-YYYY')

YADAVSLN — Mon, 14 Jan 2019 11:02:29 GMT

It's script level and UI level.

Frank_Hartmann — Mon, 14 Jan 2019 12:58:12 GMT

Yes!