Compare two dt containing dates with different format

Help Robot
,
1

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

2

Duplicated

3

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

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.