Convert date format dd-mm-yyy to dd/mm/yyyy

[Community Alums]

Hi All,

having a requirement that need to convert the data format from dd-MM-yyyy to dd/MM/yyyy on the flow designer 

by the below script in the flow designer by flow variables 

var dt = gs.nowDateTime();

return dt.toString().split(" ")[0];

the out put i'm getting dd-MM-yyyy

need to get dd/MM/yyyy

any suggestions. 

[jMarshal · Accepted solution]

You're almost there...just gotta do another split and replace the "-" with "/"

var dt = gs.nowDateTime();

dt = dt.toString().split(" ")[0];

var parts = dt.split('-');
var day = parts[0];
var month = parts[1];
var year = parts[2];

var formattedDate = day + '/' + month + '/' + year;

return formattedDate;

[jMarshal · Accepted solution]

You're almost there...just gotta do another split and replace the "-" with "/"

var dt = gs.nowDateTime();

dt = dt.toString().split(" ")[0];

var parts = dt.split('-');
var day = parts[0];
var month = parts[1];
var year = parts[2];

var formattedDate = day + '/' + month + '/' + year;

return formattedDate;

[Community Alums]

Hi @jMarshal 

The date format is coming up but its in 16/Jun/23

need to get the value like 16/06/2023.. 

any suggestions.

[jMarshal]

yup try this instead --- replacing the month from the parsed values with the numerical value:

var dt = gs.nowDateTime();

dt = dt.toString().split(" ")[0];

var parts = dt.split('-');
var day = parts[0];
var month = dt.getMonth() + 1;
var year = parts[2];

var formattedDate = day + '/' + month + '/' + year;

return formattedDate;

[Community Alums]

Hi @jMarshal 

tried as you suggested but not able to retrieve the value result as below 

need to get the date value in the format 19/06/2023.

tried another way but its not working.

var gd = new GlideDate();

return gd.getByFormat('dd/MM/yyy');

any other way to achieve this.