Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Hi,
Try like this
LOAD
*,
Alt(Date(DATE#([created Date],'D/M/YYYY')), Date(Num([created Date]))) AS Formatted_Date
FROM DataSource;
Regards,
Jagan.
replace all lines in your application with below code and run it
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='D/M/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
Directory;
LOAD Date
FROM
[Sample Dates.xlsx]
(ooxml, embedded labels, table is Sheet1);
Still Some dates are missing
please send me ur teamviewer id to my gmail account. vijayan.vipin@gmail.com
In the main tab of your script, change the variable to this one:
SET DateFormat='DD/MM/YYYY';
and you can load your excel normally, you dont need to use the date command in the field Date.
It should work...there is 23 dates just like your Excel File.
Hi Renato,
You might be true sorry for not testing your option but what gave me satisfied solution is,
LOAD
(if ((isnum(Date) = -1),Date,Date(Num#(Date)))) as Date,
Sales
;
num#() helped me here
I am sorry , I dont get your problem then. You will find in the attachment how I reached to the result.