Hi Everyone, I have 2 dt variables containing a column with dates. I want to fetch dates available in dt1 but not available in dt 2. The trick here is date format in both the columns are different. DT1 is in (dd MMM yyyy) format. Eg., 06 Jan 2023 DT2 is in (mm/dd/yyyy) format. Eg., 1/27/2023

Duplicated [image] Compare two columns from two data table variable Robot Hi Everyone, Thank you for your answers. One trick thing the dates in dt1 and in dt2 are in different format. DT1 is in (dd MMM yyyy) format. Eg., 06 Jan 2023 DT2 is in (mm/dd/yyyy) format. Eg.,…

Hi @Rupesh_Parle , You can convert all them to same format eg: by CDate(your string) them compare them regards,

Compare two dt containing dates with different format

Help Robot

Yoichi (Yoichi) October 9, 2023, 11:40pm 2

Duplicated

Topic		Replies	Views
Compare two columns from two data table variable Robot robot , question	12	592	October 10, 2023
Compare two Excel date with different Format Help	3	1793	May 4, 2020
Compare two dates in a data table Studio	12	3140	April 27, 2022
Comapre two datatable variables Robot robot , question	3	407	September 18, 2023
How to compare different date format without convert to string RPA Discussions coding , general	5	1060	January 28, 2022

Compare two dt containing dates with different format

Related topics