code error while writing a filter in between two dates in a scheduled job

servicenow begi
Tera Contributor

i have added a filter as shown below and copied the query and now i am trying to use the same query in my scheduled job and getting 

filter: Updated between 1st March 2023 to 31st March 2023, copied query is - u_region=NA^sys_updated_onBETWEENjavascript:gs.dateGenerate('2023-03-01','00:00:00')@javascript:gs.dateGenerate('2023-03-31','23:59:59')

 

servicenowbegi_0-1691177577666.png

 

now below is the error in my scheduled job, when i am copy pasting same query, please help me fix this "unexpected token 2023" error

servicenowbegi_1-1691177715023.png

 

 

 

1 ACCEPTED SOLUTION

Samaksh Wani
Giga Sage
Giga Sage

gr.addEncodedQuery("u_region=NA^sys_updated_onBETWEENjavascript:gs.dateGenerate('2023-03-01','00:00:00')@javascript:gs.dateGenerate('2023-03-31','23:59:59')")

View solution in original post

4 REPLIES 4

Rahul Talreja
Mega Sage
Mega Sage

Hi @servicenow begi ,
Can you try with 

gr.addEncodedQuery('u_region=NA^sys_updated_onBETWEEN' + javascript:gs.dateGenerate('2023-03-01','00:00:00') + '@' + javascript:gs.dateGenerate('2023-03-31','23:59:59'));
Please mark my response correct/helpful as applicable!
Thanks and Regards,
Rahul

Samaksh Wani
Giga Sage
Giga Sage

Hello @servicenow begi 

 

1. replace ' with double quotes " before u_region.

2. replace ' with double quotes " before );

Samaksh Wani
Giga Sage
Giga Sage

gr.addEncodedQuery("u_region=NA^sys_updated_onBETWEENjavascript:gs.dateGenerate('2023-03-01','00:00:00')@javascript:gs.dateGenerate('2023-03-31','23:59:59')")

thank you so much, it worked