DIFFERENT DATE FUCTIONS

[nagasekhar]

load
alt(date#(Mydate,'23-10-2018'),date#(Mydate,'20/11/2018'), date#(Mydate,'15-12-2018'),'DD/MM/YYYY') as Mydate;
date:
LOAD * Inline [

Mydate,sales
23-10-2018,100
20/11/2018,200
15-12-2018,300

];

I am getting wrong values

[tresesco · Accepted solution]

You have to pass the date formats in date#() instead of the values like:

load

Date(
alt(date#(Mydate,'DD-MM-YYYY'),date#(Mydate,'DD/MM/YYYY'))

,'DD/MM/YYYY')       as Mydate

[AshutoshBhumkar · Accepted solution]

Hi,

Use below expression :

Date(alt(date#(Mydate,'DD-MM-YYYY'),date#(Mydate,'DD/MM/YYYY'), date#(Mydate,'DD-MM-YYYY')),'DD/MM/YYYY') as Mydate;

Thanks,

Ashutosh

[nagasekhar]

load
date(alt(date#(Mydate,'23-10-2018'),date#(Mydate,'20/11/2018'), date#(Mydate,'15-12-2018'),'DD/MM/YYYY')) as Mydate;
date:
LOAD * Inline [

Mydate,sales
23-10-2018,100
20/11/2018,200
15-12-2018,300

];

still getting wrong values

[nagasekhar · Accepted solution]

load
date(alt(date#(Mydate,'23-10-2018'),date#(Mydate,'20/11/2018'), date#(Mydate,'15-12-2018'),'DD/MM/YYYY')) as Mydate;
date:
LOAD * Inline [

Mydate,sales
23-10-2018,100
20/11/2018,200
15-12-2018,300

];

but still getting wrong values

[tresesco]

@nagasekhar , you are still using wrong expression. 😋  Copy-paste the expression I posted and check.

[AshutoshBhumkar · Accepted solution]

Hi,

You are using manual dates in Date#() function.

You need to use predefined column (Created in Inline table) in Date#() function.

Use expression of  Tresesco or mine to get that correct.