Date Format issue

[#1]

Hi

My excel sheet date field have different formates of dates are available..so i need to make a proper format.How can achieve  this.

[sasiparupudi1]

post your data file

[qlikviewwizard]

Hi Karthik,

Please attach the excel file or your sample application. Thank you.

[Anonymous]

as first tip, check "Date#" in Qlikview help

this function may help you

[#5]

Date	sales
1/2/2009	400	dd-mm-yyyy
2/13/2009	5000	mm-dd-yyyy
2009/15/2	3000	yyyy-dd-mm
3/17/2009	1	mm-dd-yyyy
Required  format "DD-MM-YYYY"

[sunny_talwar]

Try this may be:

Date(Alt(Date#(Date, 'DD-MM-YYYY'), Date#(Date, 'MM-DD-YYYY'), Date#(Date, 'YYYY-DD-MM')), 'DD-MM-YYYY')

[sunny_talwar]

Only problem would be when you have a date like 01/02/2015. Would you want QlikView to interpret this like Jan 2nd 2015 or Feb 1st 2015?

[vishsaggi]

Hi Karthik,

Try this:

TableName:

LOAD Date(Date#(Date, 'DD-MM-YYYY'), 'DD-MM-YYYY')  As Date,

         Sales

FROM <Filename>.xlsx;

V.

[marcus_malinow]

A combination of alt() and date#() should work.

Alt (date#(Date, 'MM/DD/YYYY'),

    date#(Date, 'YYYY/DD/MM'),

    date#(Date, 'MM/DD/YYYY)

    )

You can add additional date# functions in here to match any additional date formats you have in your source data.

Marcus

[Anonymous]

hi,

First Use interpretation function and use formatting function to make uniform date format.

still an issue.

Please post sample data and script

Regards

Neetha