topic Re: Unable to convert the date in QlikView

Unable to convert the date

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

Hi All,

I m bit confused while trying to convert the date into desired format.IF we will change the date format in excel then O/P will come but i wanted to get the O/p at Qlik level.

PFA

Regards,

Re: Unable to convert the date

surendraj — Tue, 07 Feb 2017 12:35:00 GMT

Did u try?

Date(date#(field_name,'MM-DD-YYYY'),'DD-MMM')

Re: Unable to convert the date

Karim_Khan — Tue, 07 Feb 2017 12:45:31 GMT

S i have tried but date is coming blank

Re: Unable to convert the date

arulsettu — Tue, 07 Feb 2017 12:52:59 GMT

try this

Date(Date,'DD-MMM') as output

Re: Unable to convert the date

surendraj — Tue, 07 Feb 2017 12:54:25 GMT

In your App..

Date1=40,552,you can convert this into standard date as(your required date)

=date(date#(Date('40,552'),'DD/MM/YYYY'),'DD-MMM')-->it result as 01-sep

test field as 09/01/2009,you can convert this into standard date as(your required date)

=Date(date#('09/01/2011','MM/DD/YYYY'),'DD-MMM')-->it result as 01-sep

Re: Unable to convert the date

Karim_Khan — Tue, 07 Feb 2017 12:59:06 GMT

Tnx Surendra,I was missing that Date func