How can i embed an expression in the script?

[Mattia]

Hi Guys,

how can i embed the expression Date(Date#([DATA_CONTATTO],'DDMMYYYY'),'DD/MM/YYYY') in the script?

My script is the following:

LOAD

...

[@26:33] as DATA_CONTATTO,

...

FROM

...

Please, show me because i'm a newbie.

Thanks,

Mattia

[Frank_Hartmann · Accepted solution]

try like this:

Load 
...
Date(Date#([@26:33],'DDMMYYYY'),'DD/MM/YYYY') as DATA_CONTATTO,
...
FROM

[Mattia]

Thank you, Frank!

It works!!!

Mattia