Filter work queue between two dates

[AlexanderMcNern]

Hi,   What is the correct syntax to filter between two dates? For example, to filter all contents of a queue from 7/1/2018 to 7/31/2018?   I've tried a few to no avail, IE =>7/1/2018 && =7/1/2018, +

[Mustafa_UlasYig]

Hi amcnerney You can write ""> 01/07/2018, < 31/07/2018"" to filter queue in control-room (from 1 July to 31st July 2018). This is from the help file: ""Filter items using dates/time filters Custom filters can be applied to any of the date/time columns within the view: Specific Day Keywords such as Today, Yesterday or Tomorrow. A specific date can be entered either in local format (DD/MM/YYYY – UK), or universal date format (YYYY-MM-DD) Relative Ranges Relative ranges based on minutes, hours and days, such as Last x minutes or Next x hours or Last x days.e.g. Last 1 day or Last 5 days or Next 4 hours. Abbreviations can be used e.g. minute/min; hour/hr/h; day/dValues can also be plural (e.g. mins). Specific Ranges Specific date ranges in local or universal formats such as: • > 01/05/2014 – dates on or after 1st May 2014 • > 2014-05-01 – dates on or after 1st May 2014 • < 01/01/2016 – dates before 1st January 2016 • > 01/05/2011, < 01/06/2011 – dates on or after 1st May 2011 and before 1st June 2011"" Good luck BR, Mustafa

[Tejaskumar_Darji]

I was looking for similar solution but seems not to be working with me. It does not throw error neither it filters.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

[david.l.morris]

What value are you trying? It works for me to search for a date range by inputting a value such as this:

>3/01/2022,<4/01/2022

Of course, it probably matters what your regional date format is, but the concept would be the same.

------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------

[Ernest1]

Hi Dave,

I always use the syntax you suggested, but when I switched to an environment with a different date format (e.g. MM/DD/YYYY), unfortunately it doesn't work. I give the following date range: >09/30/2024,<11/1/2024 to get all transactions from October and unfortunately I also see transactions from 9/30/2024.

Do you have any idea to make this filter show these values ​​correctly?

Many thanks,

Marcin

[harshilcibc]

By default it uses time as -00:00. Use time along with date. 

E.g., > 02/19/2025 -0:00, < 02/20/2025 -0:00

This will return any item starting from 19 Feb 12:00 AM to 19 Feb 11:59:59PM. 

02/19/2025 -4:00

This will return item what are loaded at 4:00 AM. 

-hh:mm or -h:mm is for the data time visible on UI as per system timezone, not datetime from DB, which has UTC datetime.