Change Date Format in Script

[bazzaonline]

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

[Gysbert_Wassenaar]

LOAD

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

...other fields...

FROM ...