Change Date Format in Script

bazzaonline — Mon, 09 Mar 2015 15:17:04 GMT

Hello,

I'm trying to join to sets of data and then do a sum however need to amend the date format in the script.

It currently looks like the below but needs to be dd/mm/yyyy, I tried Date(NotificationDate,'dd/mm/yyyy) AS NotificationDate and it doesn't bring back the correct result.

Please help

Re: Change Date Format in Script

Gysbert_Wassenaar — Mon, 09 Mar 2015 15:21:43 GMT

LOAD

date(date#(NotificationDate, 'YYYY-MM-DD hh:mm:ss.ffff'),'DD/MM/YYYY' as FormattedNotificationDate,

...other fields...

FROM ...

topic Change Date Format in Script in QlikView

Change Date Format in Script

Re: Change Date Format in Script