Convert Date in Script

[#1]

Hi, how can i convert date in script from 08-OCT-10 to 08.11.2011 ?

Thanks

[swuehl · Accepted solution]

Try using date format function DATE(), like

LOAD ...

Date(YOURDATEFIELD,'DD.MM.YYYY') as NEWDATEFIELD,

...

check out format codes.

Other way is changing the system variables DateFormat at the top of your script.

Hope this helps,

Stefan

[#3]

Thanks, That works fine.