Date Format

[QlikEnth]

Hello Experts,

i can achieve the Date Format from the Column with the Date Sets Like "Mon Dec 31 02:00:00 EST 2018" Using the Right and  Left Functions and get the Date Format as '12/31/2018' or '12-31-2018', But is there any simple way than the Complex Way ?

Thanks.

[Anil_Babu_Samineni]

Please provide more rows how data looks like?

[QlikEnth]

Column Data Looks Like Below, just need the Date Format

Fri Mar 06 15:00:00 EST 2015

Fri Mar 06 15:00:00 EST 2015

Fri Mar 06 10:00:00 EST 2015

Fri Mar 06 10:00:00 EST 2015

Mon Mar 09 15:00:00 EDT 2015

Mon Mar 09 17:00:00 EDT 2015

Mon Mar 09 17:00:00 EDT 2015

[Anil_Babu_Samineni · Accepted solution]

Since there is some string between the format like EDT, EST etc. I can think Subfield can deserve

=Date(Date#(SubField(Field, ' ', 3) &'/'& SubField(Field, ' ', 2)&'/'&SubField(Field, ' ', -1), 'DD/MMM/YYYY'))

[QlikEnth]

Thanks Anil,

This Worked as Expected