Unable to convert date format to DD-MM-YYYY

[sainath3]

Hi All,

In my User profile changed the date format to dd-MM-yyyy.

am loading the data thr transform, in source table for the start date field  i have taken as string.

in Source table date is 19-03-2025.

Am just mapping to the target field, but in target field it showing as "14-09-0024".

If I try with new GlideDateTime() it is returning as "2025-03-19"

Don't know how it has changed.

but I want date should be same as Source table date "19-03-2025"

Can you please help me.

[Shree_G · Accepted solution]

Hello @sainath3 ,

You can use below code to ensure the format.

var new gdt = new GlideDate();

gdt.getByFormat("dd-MM-yyyy");

[sainath3]

Hi Shree,

I tried the same but no user, still same wrong format