Date conversion in script

[iswarya]

convert this date 5-17-2019 12:00:00 AM to dd-mm-yyyy  format

[Edvin]

Try this:
date#(FieldName,'DD-MM-YYYY')

[AjithramT]

hi,

try like this

date(date#('5-17-2019 12:00:00','MM-DD-YYYY hh:mm:ss'),'DD-MM-YYYY')

[iswarya]

But i want to convert all the dates in my StartDate field. It's not working

[hamzabob1]

Try this

Date(trim(DateField),'DD/MM/YYYY') as Date.