How to Change Date Format 9/27/2023 to MM-dd-yyyy?

[Community Alums]

I have used below code to convert the date format but didn't worked. 

var gr = '09/27/2023';

var gd = new GlideDate(); 
gd.setValue(gr);
gs.info(gd.getByFormat("MM-dd-yyyy"));

But Getting below error in background script:

"Unparseable date: "09/27/2023": java.text.ParseException:"

Please help me on this!

[Mark Roethof]

Hi there,

Where is this 09/27/2023 coming from? Can you provide more details? This is not what's actually stored in the XML of the record, correct?

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Jaspal Singh · Accepted solution]

Hi Ganesh,

Can you try below in bacgkground script once for a check.

var gr = '09/27/2023';
var gd = new GlideDateTime(gr).getDate(); 
//gd.setValue(gr);
gs.info(gd.getByFormat("MM-dd-yyyy"));

[Community Alums]

@Jaspal Singh Thank You so much for your reply. 

[Ankur Bawiskar]

@Ganesh Manasali 

updated script below

var gr = '09/27/2023';
var gdt = new GlideDateTime();
gdt.setDisplayValue(gr, "MM/dd/yyyy");
var formattedDate = gdt.getDate();
var time = new GlideDate();
time.setValue(formattedDate);
gs.info(time.getByFormat("MM-dd-YYYY"));

Output:

Regards
Ankur