How can i compare the planned end date time with the current date time in change request and if the current date time is greater than the planned end date time then i need to update the change task 's work notes. (script in Schedule job)

[Mano R]

How can I compare the planned end date time with the current date time in the change request if the current date time is greater than the planned end date time then I need to update the change task's work notes. (script in Schedule  job)

[Kieran Anson]

You can use a relative GlideRecord query, best (and easiest way) is to use the list view to build your query, and then right click the query string to get the encoded query value.

[Mano R]

Hi @Kieran Anson 

what is the correct query to build 

how to check  if the planned end date time(field in change task form) is greater than the current date time

[Harneet Sital]

Hi Mano, 

Here is how you can create this query, once done copy the query and add it your job

Thanks
-Harneet Sital (ServiceNow Certified Technical Architect)
Request you to please mark my answer as helpful or correct based on the impact
Find all my ServiceNow articles here