question Re: getByFormat is not working as expected in Developer forum

getByFormat is not working as expected

xavifrancis — Fri, 13 Mar 2020 05:52:02 GMT

The below script is not working as expected.

The variable longDateTime should print value as "December 31, 2019" but it is printing as "December 31, 2020".

var current = new GlideRecord('proc_po');
current.addEncodedQuery('u_amat_poSTARTSWITH4400475274');
current.query();
if(current.next()){
var gDateTime = new GlideDateTime(current.po_date.getDisplayValue());
var gDate = gDateTime.getDate();
gs.print(gDate); // prints - 2019-12-31 - correct value
var longDateTime = gDate.getByFormat("MMMM dd, YYYY");
gs.print(longDateTime); // prints - December 31, 2020 - wrong year
}

Need help to fix this.

Thanks,

Francis Xavier K.

Re: getByFormat is not working as expected

Ankur Bawiskar — Fri, 13 Mar 2020 05:59:57 GMT

Hi Francis,

can you print the gDateTime value?

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Re: getByFormat is not working as expected

xavifrancis — Fri, 13 Mar 2020 06:10:40 GMT

Hi Ankur,

below is the output we are getting for gDateTime.

2019-12-31 13:30:00

Re: getByFormat is not working as expected

hvrdhn88 — Fri, 13 Mar 2020 06:12:01 GMT

try now.

var current = new GlideRecord('proc_po');
current.addEncodedQuery('u_amat_poSTARTSWITH4400475274');
current.query();
if(current.next()){
var gDateTime = new GlideDateTime(current.po_date);

gDateTime.getDisplayValueInternal();

var gDate = gDateTime.getDate();
gs.print(gDate); // prints - 2019-12-31 - correct value
var longDateTime = gDate.getByFormat("MMMM dd, YYYY");
gs.print(longDateTime); // prints - December 31, 2020 - wrong year
}

Re: getByFormat is not working as expected

xavifrancis — Fri, 13 Mar 2020 06:29:54 GMT

It gives the same result.

Check the below simplified script:

var a = '2019-12-31 08:00:00';
var gDateTime = new GlideDateTime(a);
var gDate = gDateTime.getDate();
gs.print(gDate); // prints - 2019-12-31 - correct value
var longDateTime = gDate.getByFormat("MMMM dd, YYYY");
gs.print(longDateTime); // prints - December 31, 2020 - wrong year

which gives the same result.

Re: getByFormat is not working as expected

hvrdhn88 — Fri, 13 Mar 2020 06:31:43 GMT

ohk got the issue. try now , i have tested it.

var a = '2019-12-31 08:00:00';
var gDateTime = new GlideDateTime(a);
var gDate = gDateTime.getDate();
gs.print(gDate); // prints - 2019-12-31 - correct value
var longDateTime = gDate.getByFormat("MMMM d, yyyy");
gs.print(longDateTime); // prints - December 31, 2020 - wrong year

If my answer helped you, kindly mark it as correct and helpful.

Re: getByFormat is not working as expected

hvrdhn88 — Fri, 13 Mar 2020 06:33:18 GMT

for future reference, you can refer the below link for correct date format string.

https://help.talend.com/reader/3zI67zZ9kaoTVCjNoXuEyw/YHc8JcQYJ7mWCehcQRTEIw

If my answer helped you, kindly mark it as correct and helpful.

Re: getByFormat is not working as expected

Jorn van Beek — Fri, 13 Mar 2020 06:35:25 GMT

put the YYYY as yyyyy (from upper case to lower case).

the upper case format gives back 'year of week', 31 december could be in week 1 of the next year.

the lower case format gives back 'current year', what you are looking for.

Re: getByFormat is not working as expected

xavifrancis — Fri, 13 Mar 2020 06:42:10 GMT

Thank you Harshvardhan...

It works fine now