Unable to convert the date

[Karim_Khan]

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,

KK

[surendraj]

Did u try?

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

[Karim_Khan]

S i have tried but date is coming blank

[arulsettu]

try this

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

[surendraj · Accepted solution]

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

[Karim_Khan]

Tnx Surendra,I was missing that Date func