Avatar

Correct answer by
Employee Advisor

Hi Sakthikumar,

I'm not able to catch the complete context of your requirement, but you can try one of the following:

  1. Use <compute-string> inside schema to generate a computed column in the desired string format.
  2. On the fly, inside your workflow you can use the available SQL function to convert them to desired format.
  3. Inside delivery, make use of JS code to convert them in desired formation using formatDate() function and use for personalization.

Hope it helps.

Regards,

Vipul

View solution in original post