topic Re: Date Format in App Development

Date Format

QlikEnth — Sat, 16 Nov 2024 05:04:57 GMT

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.

Re: Date Format

Anil_Babu_Samineni — Fri, 02 Aug 2019 15:32:49 GMT

Please provide more rows how data looks like?

Re: Date Format

QlikEnth — Fri, 02 Aug 2019 15:41:40 GMT

Column Data Looks Like Below, just need the Date Format

Fri Mar 06 15: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

Re: Date Format

Anil_Babu_Samineni — Fri, 02 Aug 2019 16:02:35 GMT

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

Re: Date Format

QlikEnth — Tue, 17 Sep 2019 18:47:50 GMT

Thanks Anil,

This Worked as Expected