getByFormat is not working as expected!?

[Ravi Chandra_K]

the expected output is 2005-01-31 but I'm getting 0036-06-27. how to resolve this?

[Ankur Bawiskar]

Hi,

you can send the values to script include as it is. Also send the logged in user's date format to Script include function

in client script you can use this to get the user's date format

var format = g_user_date_format; // send this to ajax

Then inside script include convert that user given format to system one and get the duration

Can you share your script include code

Regards
Ankur

[PrashantLearnIT]

Hi Ravi,

Please try to use the below logic, if it helps you.

var date= new GlideDate();//replace new GlideDate() with the incoming date
var date2 = date.getByFormat('yyyy/MM/dd');//now use the date2 to set the field value

Prashant

If my answer helped you in any way, please mark this answer as helpful and correct.

[Muhammad Khan · Accepted solution]

Hi Kukunooru,

Use the following in background script;

var gd = new GlideDateTime();
gd.setValue('31-03-2005');
gs.print(gd.getDate());

*** Script: 2005-03-31

Hopefully, this will resolve your query.

[Ravi Chandra_K]

Thank you Muhammad,

it is giving expected output. but the substract method is not working with correct date formats.

[Muhammad Khan]

You should return diff.getDisplayValue(); which will return actual duration.