Get Display Value of Date field

[JJG]

Hello,

I am using a business rule to pull the value of a date field called 'date'. I am trying to get its display value but am hitting some difficulties. What am I missing?

var grContract = new GlideAggregate('x_utsll_time_manag_hour_tracker');
grContract.addQuery('name_of_employee', name);
grContract.query();
while (grContract.next()) {
     var date = grContract.date.getDisplayValue();
     gs.info('Date: '+date);

}

Output::

[Mark Roethof]

Don't know if this is your full code, if it is indeed your fullcode. Can you also double check:

grContract.addQuery('name_of_employee', name);

==> name.

What is name here?

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

[JJG]

I did some testing and it seems like its the GlideAggregate thats the problem. When I turn it into a GlideRecord it works fine. Any idea why?

[Tanushree Doiph]

Hey,

Try this code,

var date =  gr.Contract.getDisplayValue('date');

Thanks

Tanushree

[Ankur Bawiskar]

Hi,

why you require displayValue() on date field? if you use grContract.date it should directly give you the value

you can use this syntax; use proper field name for "date" inside the getDisplayValue() method

var date = grContract.getDisplayValue('date');

gs.info('Date: ' + date);

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

[Allen Andreas]

Hello,

This type of thing causes a thread to go all out of control heh...

So firstly, you are using a variable name, like 'date', which can be possibly reserved by the system...so I'd personally recommend you use other types of variable names and not stuff like "date, answer, return" which could be used by the system or JavaScript in other ways. That's just my opinion...but from experience, it helps cause something small like this to not even be a concern or possibility of an issue.

Secondly, is your field named "date", literally, on this table: x_utsll_time_manag_hour_tracker

What else in your script are you not showing here? As you're using "name" in your addQuery and from your code provided, to us, name is not defined.

I'd recommended checking those things over and seeing if you have better results.

Please mark reply as Helpful/Correct, if applicable. Thanks!