Hi Boyan,

It's returning 0. But when I go with static way, it's returned 2 which was correct count. 

Javascript compiler exception: missing ) after argument list (<refname>; line 1) in:
gs.dateGenerate(date,12:00:00)
Javascript compiler exception: missing ) after argument list (<refname>; line 1) in:
gs.dateGenerate(dateOne,14:00:00)
*** Script: test count 0

Thanks,

Raj

Can you please check this one

var date = "2022-03-31";
var timestart = "00:00:00";
var timeend = "10:00:00";

var incident = new GlideRecord("incident");
incident.addEncodedQuery("sys_created_onONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()^sys_created_onBETWEENjavascript:gs.dateGenerate('" +date + "','" + timestart +"')@javascript:gs.dateGenerate('" + date + "','" + timeend+"')");
incident.query();
gs.info("test count "+incident.getRowCount());

In your query I see dateOne.

javascript:gs.dateGenerate(dateOne,timeend)

Where is this defined?

Hi Anirudh,

This below is the script which I am using, that was mistakenly I used wrong variable.

var date = "2022-03-31";
var timestart = "12:00:00";
var timeend = "14:00:00";

var incident = new GlideRecord("incident");
incident.addEncodedQuery("sys_created_onONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()^u_glide_date_time_1BETWEENjavascript:gs.dateGenerate(date,timestart)@javascript:gs.dateGenerate(date,timeend)");
incident.query();
gs.info("test count "+incident.getRowCount());

Thanks,

Raj