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:

[fashid]

Hi Guruprem,

do you have these dates somewhere else also in the application.

This could be a result of cancatenation of dates further in the script where you may not have formatted the date.

If not preferably attach your app.

Regards,

Nadeem

[jonathandienst]

Try it on the sample you posted. It works there. So it looks like your problem is somewhere else in your data.

[#4]

Hi Guruprem,

Can you please either change the Date format in excel - DD/MM/YYYY to M/D/YYYY  or change qlikview default date format to  D/M/YYYY ?

SET DateFormat='D/M/YYYY';

While reading data from excel , qlikview has converted valid date formats to number and others are strings. I don't know whether is other solutions, haven't tried it myself

Thanks & Regards,
Vipin

[avinashelite]

Hi

use this it will work:

=if(IsNum([created Date])=-1,Date(DATE#([created Date],'DD/MM/YYYY')),Date(Date#([created Date],'DD/MM/YYYY'),'DD/MM/YYYY'))

[#6]

Confident about this , let me check

[#7]

Tried, Result is same ., Issue still persists

[#8]

Did u change the format in excel or in qlikview??/

[jagan]

Hi,

Try like this

LOAD

*,

Alt(Date(DATE#([created Date],'D/M/YYYY')), Date([created Date])) AS Formatted_Date

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[#10]

Even this led to the only 11 dates in o/p where as I have 24 dates in Excel

[#11]

Even this led to the only 11 dates in o/p where as I have 24 dates in Excel