Use 'greater than or equal to' to compare two date fields

[JJG]

Hello,

I have a script include that searches a table. It should pull records if the 'pay_period_end' date field is greater than or equal to today's date. It doesn't seem to work, is there an error? It works when I remove my grPayPeriod.addQuery line.

get_payPeriod: function() {

var dateToday = new GlideDate();
var grPayPeriod = new GlideRecord('x_utsll_time_manag_hour_tracker');
grPayPeriod.addQuery('pay_period_end' >= dateToday);
grPayPeriod.query();

if (grPayPeriod.next()) {
return grPayPeriod.getValue('pay_period');
}
},

[sachin_namjoshi · Accepted solution]

Use below code

get_payPeriod: function() {

var dateToday = new GlideDate();
var grPayPeriod = new GlideRecord('x_utsll_time_manag_hour_tracker');
grPayPeriod.addQuery('pay_period_end', ">=",dateToday);
grPayPeriod.query();

if (grPayPeriod.next()) {
return grPayPeriod.getValue('pay_period');
}

Also, check useful blog for date field validations.

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

Regards,

Sachin

[Tanaji Patil]

This wont give proper results because of time difference.

GlideDate() will give you date in your timezone whereas the fields value in the backend is in GMT.

-Tanaji

Please mark reply correct/helpful if applicable

[sachin_namjoshi]

You can't assume that since you don't know poster's instance.

I was correcting typo in his code.

Anyway, blog has solution to validate date fields.

Regards,

Sachin

[Tanaji Patil]

I understand you corrected typo and I really appreciate helping others.

Having said that you can't assume poster is a male;)

-Tanaji

Please mark reply correct/helpful if applicable