Reading Dates

[#1]

Experts ,

Many times I faced dates issues but none of old techniques worked. Could you please help me to read the dates here.

[Output]:

LOAD 

ALT(DATE#(Date,'D/M/YYYY'),DATE#(Date,'DD/M/YYYY'),DATE#(Date,'D/MM/YYYY'),DATE#(Date,'DD/MM/YYYY'))as Date,

Sales

RESIDENT [Dress Sales] ;

But My Output is:

My Source is:

[mightyqlikers]

Hi,

Please share sample data.

samwise

[#3]

Sample data is attached

[avinashelite]

Hi Guruprem,

Few of the data is store as numeric I guess that's why your facing the issues. Please post your  app so that we can help you out.

[mightyqlikers]

Please find the attached qvw

Regards

Samwise

[#6]

I am using PE, Could you post script?

[fashid]

Hi,

use this

Directory;

LOAD

  Date,

  Date(Date#(Date,'DD/MM/YYYY'),'DD-MM-YYYY') as DATES

FROM

[Sample Dates.xlsx]

(ooxml, embedded labels, table is Sheet1);

regards

nadeem

[jonathandienst]

Hi

I think its just a formatting issue. This works with your sample data:

Date(DATE#(Date,'DD/MM/YYYY'))as Date

HTH

Jonathan

[#9]

I tried this, it output date is not showing some dates(Text dates as shown in first post )

[#10]

I tried this, it output date is not showing some dates(Text dates as shown in first post) . I mean there should be 24 dates in output but only 14 dates are showing