In workflow javascript. New date() return "wrong" date/time.

Hi ​@Hans Andersen 

try this

var currDate = new Date();
var isoDate = currDate.toISOString();
var formattedDate = isoDate .replaceAll('T', '-').replaceAll(':','.').slice(0, -5);
execution.setVariable(' formattedDate', formattedDate); 

Hi,

Adding to the above, currently the BPA workflow engine supports the following DATETIME formats:

• yyyy-MM-dd-HH.mm.ss (2023-09-21-07.04.39)
• yyyy-MM-dd-HH.mm.ss.SSSSSSS (2023-09-22-08.04.39.0000000)

https://docs.ifs.com/techdocs/24r2/040_tailoring/500_business_process_automation/250_workflow_faq/

You can also use the following JavaScript to convert dates and timestamps to support the BPA workflow engine:

var cNow = new Date();
var cToday = cNow.toLocaleDateString();
execution.setVariable("EffectiveDate", cToday );

-------------------------------------------------------------------------------------------------------------------------------------------------
var SimpleDateFormat = Java.type("java.text.SimpleDateFormat");
var Date = Java.type("java.util.Date");
var currentDate = new Date();
var sdf = new SimpleDateFormat("yyyy-MM-dd-HH.mm.ss");
var formattedDate = sdf.format(currentDate);
execution.setVariable("Cf_Pcx_Datetime", formattedDate);

var now = new Date();
var isoString = now.toISOString();
var datePart = isoString.substring(0, 10);
var timePart = isoString.substring(11, 19).replace(/:/g, '.');
var datetime = datePart + '-' + timePart ;
execution.setVariable("Pcx_Datetime", datetime );