Query condition for between start and end date

[Rajeshkumar2]

Hi,

I have a requirement to get the records count which was created between start and end date using fix script.

It was worked, when I try the below query condition using static way like directly added date and time.

var incident = new GlideRecord("incident");
incident.addEncodedQuery("sys_created_onONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()^u_glide_date_time_1BETWEENjavascript:gs.dateGenerate('2022-03-31','12:00:00')@javascript:gs.dateGenerate('2022-03-31','14:00:00')");
incident.query();
gs.info("Total count"+incident.getRowCount());

But it's not worked when I try to add those date and time in separate variable and called that variable in my query condition like below. Can any one please let me know the way to achieve this one?

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(dateOne,timeend)");
incident.query();
gs.info("test count "+incident.getRowCount());

Thanks,

Raj

[AnirudhKumar]

In your query I see dateOne.

javascript:gs.dateGenerate(dateOne,timeend)

Where is this defined?

[Rajeshkumar2]

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