Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Date Format

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.

Labels (1)
1 Solution

Accepted Solutions
Highlighted

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'))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

4 Replies
Highlighted

Please provide more rows how data looks like?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II
Contributor II

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

 

Highlighted

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'))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
Contributor II
Contributor II

Thanks Anil,

 

This Worked as Expected