Is javascript code activity supports the sql function?

[#1]

I am trying to use function to convert the date format into the string for ex (12/06/2016 to 12-Jun-2016)

Without creating and importing package into the adobe campaign, Is there any alternative option to do that activity.

[#2 · Accepted solution]

Hi Sakthikumar,

JavaScript code activity will allow running JS based functions. You can convert the string to a Date object and then perform transformations on it.

Regards,

Vipul

[#3]

did you tried formatDate(date,"%2D-%3B-%4Y"), if this doesn't work post the error logs here. may be your user doesn't have required rights i.e admin rights.