Issue Comparing Schedule Date/Time Field with Today’s Date

kaustubh Desai
Tera Guru

Hello all,

I'm trying to retrieve records from the cmn_schedule_span table where the start_date_time (a Schedule Date/Time type field) is greater than today's date.

Here’s a simplified version of the script I’m using for testing:

var gr = new GlideRecord('cmn_schedule_span');
gr.get('sys_id'); // Example sys_id for testing

var dateIS = gr.getDisplayValue('start_date_time');
gs.info('Display Value: ' + dateIS); // e.g., "05/19/2025 19:00:00"

var spanDate = new GlideDateTime(dateIS);
var numValueSpanDate = spanDate.getDate().getNumericValue();
gs.info('spanDate Numeric: ' + numValueSpanDate);

var today = new GlideDateTime();
var numValueToday = today.getDate().getNumericValue();
gs.info('today Numeric: ' + numValueToday);

if (spanDate > today) {
gs.info('Condition met: spanDate is after today');
}

Even when the numeric values of both dates are equal, the script still enters the if (spanDate > today) condition. I suspect this might be due to the Schedule Date/Time field type, possibly involving internal time zone handling or precision differences.

Has anyone else encountered this behavior?
Any advice on how to reliably compare a Schedule Date/Time field with the current date (ignoring time) would be appreciated.

Thanks in advance!

1 ACCEPTED SOLUTION

pratikjagtap
Giga Guru

Hi @kaustubh Desai ,

 

Option 1: Compare Only the Date Portion
If you're interested in just comparing dates (not times):

if (numValueSpanDate > numValueToday) {
gs.info('Condition met: spanDate is after today (by date only)');
}

 

Option 2: Truncate Time in GlideDateTime
If you must work with GlideDateTime, zero out the time portion to compare dates only:

 

function getStartOfDayGDT(gdt) {
var dateStr = gdt.getDate().toString(); // yyyy-MM-dd
return new GlideDateTime(dateStr + ' 00:00:00');
}

var truncatedToday = getStartOfDayGDT(today);
var truncatedSpan = getStartOfDayGDT(spanDate);

if (truncatedSpan.after(truncatedToday)) {
gs.info('spanDate is after today (date-only check)');
}

 

If my response helped, please hit the 👍Thumb Icon and accept the solution so that it benefits future readers.

 

Regards,
Pratik

View solution in original post

1 REPLY 1

pratikjagtap
Giga Guru

Hi @kaustubh Desai ,

 

Option 1: Compare Only the Date Portion
If you're interested in just comparing dates (not times):

if (numValueSpanDate > numValueToday) {
gs.info('Condition met: spanDate is after today (by date only)');
}

 

Option 2: Truncate Time in GlideDateTime
If you must work with GlideDateTime, zero out the time portion to compare dates only:

 

function getStartOfDayGDT(gdt) {
var dateStr = gdt.getDate().toString(); // yyyy-MM-dd
return new GlideDateTime(dateStr + ' 00:00:00');
}

var truncatedToday = getStartOfDayGDT(today);
var truncatedSpan = getStartOfDayGDT(spanDate);

if (truncatedSpan.after(truncatedToday)) {
gs.info('spanDate is after today (date-only check)');
}

 

If my response helped, please hit the 👍Thumb Icon and accept the solution so that it benefits future readers.

 

Regards,
Pratik