Convert format of glidedatetime from YYYY-MM-DD to YYYY-MMM-DD

PranavSuj96 · ‎03-25-2019

Hello all,

I have a script include which gets me tomorrow's date. However it sends it back to my client script in the wrong format.

I tried using getByFormat("YYYY-MMM-DD HH:MM:SS") on the GDT variable, however this functionality is not available on KINGSTON. Not sure how to proceed...

Thanks

Pranav

Abhishek Pidwa · ‎03-25-2019

Hi ,

It seems that this function is still available on Kingston and I tried in my PDI to test it. Can you post the entire script as to how are you using that function ?

https://developer.servicenow.com/app.do#!/api_doc?v=kingston&id=r_ScopedGlideDateGetByFormat_String

var gd = new GlideDate();
gd.setValue('2015-01-01');
gs.info(gd.getByFormat("dd-MMM-yyyy HH:MM:SS"));

Thanks.

View solution in original post

Abhishek Pidwa · ‎03-25-2019

Yup so for that you can use the function which I provided earlier :

var gDate = new GlideDate();
gDate.setValue('2015-01-01');
gs.info(gDate);
 
var gDT = new GlideDateTime(gDate);
gs.info(gDT);

This will convert your Glide Date to Glide Date Time without manually inputting anything. try this.

PranavSuj96 · ‎03-25-2019

This isn't a constructor that is available on Kingston.

Abhishek Pidwa · ‎03-25-2019

Sorry man couldn't figure this out in Kingston. I would suggest raise another question on this community with your exact requirements and somebody should be able to help you out.

Happy coding.

Thanks

PranavSuj96 · ‎03-25-2019

Hey nw! Thanks for all the help 🙂

sachin_namjoshi · ‎03-25-2019

Check below blog for time format converting

https://community.servicenow.com/community?id=community_blog&sys_id=bc0e6a2ddbd0dbc01dcaf3231f961931

Regards,

Sachin