Revision history [back]

To format dates using PQL and JS in Adobe Journey Optimizer, you can use the following code:

1. PQL:

select format("my_date_field", "yyyy-MM-dd") as "formatted_date" from my_schema.my_table

This code will format the date in the "mydatefield" column of the "mytable" table in the "myschema" schema as "yyyy-MM-dd" and rename the formatted date as "formatted_date".

1. JS:

var date = new Date("2022-02-20");
var formattedDate = date.toLocaleDateString('en-US', { year: 'numeric', month: '2-digit', day: '2-digit' });
console.log(formattedDate);

This code will format the date "2022-02-20" as "MM/dd/yyyy" using the toLocaleDateString() function and log it in the console. You can modify the function's parameters to format the date in different ways.