Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Convert Date in Script

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

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Convert Date in Script

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

2 Replies
MVP
MVP

Convert Date in Script

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

Not applicable

Convert Date in Script

Thanks, That works fine.