Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
keerthika
Creator II
Creator II

Date Format Conversion

Hi All,

     Can any one say how to convert '4th june 2018' to '04june2018', need to convert string to date,

     I'm having many formats , like below

    January 1st 2018
February 1st 2018
April 1st 2018
July 1st 2018
11/1/2018
10/1/2018
2018
2018
October 1st 2018
October 1st 2018
November 1st 2018
12/1/2018
1/1/2019
1/1/2019
February 8th 2018
February 8th 2018
April 1st 2018
October 5th 2018
October 5th 2018
November 1st 2018
November 1st 2018
February 6th 2018

 

Thanks,

Keke

5 Replies
tresesco
MVP
MVP

Use alt() in combination with date#()to convert the string into unified date format, like shown here:

Multiple-Dates-Using-Alt

keerthika
Creator II
Creator II
Author

Hi,
Iam using qlikview , does this work?
keerthika
Creator II
Creator II
Author

For this format its not working (3rd june 2018)
albert_guito
Creator II
Creator II

Hi,
If you want to convert '4th june 2018' to '04june2018' you can try with:

If(Len(SubField(PurgeChar([YourField],'th'),' ',1))=1,0&Left([YourField],1),Left([YourField],2)&SubField([YourField],' ',2)&Subfield([YourField],' ',3)

Also you can add to PurgeChar function the rest for ordinals letters ... st, nd, etc.

Ag+
Ag+
jonathandienst
Partner - Champion III
Partner - Champion III

Or try this

Date(
    If(WildMatch(DateField, '*st *', '*nd *', '*rd *','*th *'),
        Date#(
            KeepChar(SubField(DateField, ' ', 2), '0123456789') & '-' & 
            SubField(DateField, ' ', 1) & '-' & 
            SubField(DateField, ' ', 3), 'D-MMMM-YYYY),
        Alt(
            Date#(DateField, 'YYYY'),
            Date#(DateField, 'DD/MM/YYYY')
        )
    )
) as DateValue

 

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein