Discussion board where members can learn more about Qlik Sense App Development and Usage.
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 ?
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'))
View solution in original post
Please provide more rows how data looks like?
Column Data Looks Like Below, just need the Date Format
This Worked as Expected