Querying Incident table for date range

[monicanegi]

Hi ,

I am trying to fetch closed records from Incident table using below request-

I have two closed records with closed_at date as

2017-04-12 19:13:11

2017-05-25 09:29:01

1.Trying to fetch records with closed_at date > '2017-04-12 19:13:10', so i was expecting that it should fetch '2017-04-12 19:13:11'record as well, but it didn't fetch that record.

I had tried with '2017-04-12 19:00:00' as well but it didn't work either.

https://dev34617.service-now.com/api/now/table/incident?sysparm_query=closed_at%3Ejavascript%3Ags.da...

Although >'2017-04-12 00:00:00' does fetch '2017-04-12 19:13:11'.

2. Also trying with >= '2017-04-12 19:13:11', didn't work.

https://dev34617.service-now.com/api/now/table/incident?sysparm_query=closed_at%3E=javascript%3Ags.d...

3.Whereas fetching records < '2017-04-12 19:13:12' , fetches '2017-04-12 19:13:11' record .

https://dev34617.service-now.com/api/now/table/incident?sysparm_query=closed_at%3Cjavascript%3Ags.da...

Also with <='2017-04-12 19:13:11', it fetches the '2017-04-12 19:13:11' record

https://dev34617.service-now.com/api/now/table/incident?sysparm_query=closed_at%3C=javascript%3Ags.d...

4.While trying to fetch data within a date range (startdate as '2017-04-12 19:13:11' and enddate as '2017-05-25 09:29:01'), it fetches '2017-05-25 09:29:01' record but not '2017-04-12 19:13:11'

https://dev34617.service-now.com/api/now/table/incident?sysparm_query=closed_atBETWEENjavascript%3Ag...

So it seems that > and >= are not working as expected. Please help me in resolving this issue and let me know how to use > and >= in my request.

Thanks,

Monica

[monicanegi]

Hi Midhun,

Other fields are working fine.Not sure is it's issue in developers instance(Geneva version).

I had tried creating report and checked for other fields, facing problem with "at or after" and "between " on my developer instance.

Thanks,

Monica