time format

[qvqfqlik]

time format expression is working in set expression but its not working when I use it in data load editor.

[sunny_talwar]

can you share more details?

[qvqfqlik]

this works in  set expressions but doesn't work when I use the same in the script

date(Date#([datefield],'MM/DD/YYYY hh:mm:ss TT'),'DD/MMM/YYYY hh:mm:ss TT')