Hi all, I have one excel file with “Delivery date” column, Column contains dates. I need to check if “Delivery date” is greater or smaller than date on next Wednesday. We can’t hardcode date. [image] Thanks in advance

@Ulhas_Guttikar Kindly refer to the Xaml file attached here :point_down: Forum_ExcelDayFilter.zip (98.7 KB) In this process, Modify date activity was used to identify the next or pervious day based date. [image]

How to check if Available date is Greater or smaller than date on next Wednesday

Help Studio

Gokul_Jayakumar (Gokul Jai) September 27, 2022, 6:25am 5

@Ulhas_Guttikar
It’s my pleasure

Happy Automation

Regards,
Gokul Jai

Topic		Replies	Views
How to compare whether a date is greater than another Studio datatable , activities , question	4	7524	April 26, 2020
How to find the date is less or greater than today days Activities datatable , excel , selector , uiautomation , mail , orchestrator , robot , activities , studio , studiox , question , activities_panel	5	1269	August 22, 2024
How to compare date in Excel with actual date? Studio studio , question , activities_panel	2	4382	February 15, 2023
How to check if current date is in under or equal to 60 days Studio studio , question , designer_canvas	3	2089	January 8, 2022
How do I get to know if a date has passed or not? Activities excel , activities , question	3	623	December 21, 2022

How to check if Available date is Greater or smaller than date on next Wednesday

Related topics