Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Different Date Formats

Hi

I have a QV Model that is extracting data from various excel spreadsheets.  I have a field called "Claim Date" , where the date format is is not consistent in these excel spreadsheets.  How do i create a formula in a list box to show a consistent date format as'DD-MMM-YY". (see below).

Kind regards

Nayan

  

Claim DateIdeal Claim Date Format
2013-07-1717-Jul-13
2013-07-1616-Jul-13
2013-07-0909-Jul-13
2013-07-0707-Jul-13
2013-07-0606-Jul-13
42649.2136906-Oct-16
42644.1238401-Oct-16
42644.1238301-Oct-16
42642.4055429-Sep-16
42642.4054429-Sep-16
42641.2742728-Sep-16
42641.2742128-Sep-16
42640.2169427-Sep-16
4263320-Sep-16
4263219-Sep-16
4263118-Sep-16
4263017-Sep-16
4262916-Sep-16
4220520-Jul-15
4215228-May-15
4213713-May-15
4212430-Apr-15
4211420-Apr-15
1 Solution

Accepted Solutions

Re: Different Date Formats

A small addition to the field-values which are a timestamp and not a date:

Alt(Date(floor([Claim Date]),'DD-MMM-YYYY'),Date(Date#([Claim Date],'YYYY-MM-DD'),'DD-MMM-YYYY'))

- Marcus

5 Replies
antoniotiman
Honored Contributor III

Re: Different Date Formats

Hi,

try

Alt(Date([Claim Date],'DD-MMM-YYYY'),Date(Date#([Claim Date],'YYYY-MM-DD'),'DD-MMM-YYYY'))

Regards,

Antonio

Not applicable

Re: Different Date Formats

Thank you Antonio

Re: Different Date Formats

A small addition to the field-values which are a timestamp and not a date:

Alt(Date(floor([Claim Date]),'DD-MMM-YYYY'),Date(Date#([Claim Date],'YYYY-MM-DD'),'DD-MMM-YYYY'))

- Marcus

Not applicable

Re: Different Date Formats

Hi Marcus

Thank you.

Kind regards

Nayan