Dates not merging after formatting them

[sindisa12]

Good day,

I have dates from different tables which i have formatted the same as

Monthend(Date(Date#(right(FileBaseName(),6),'YYYYMM'),'YYYY\MM\DD')) as Date  - this one is derived from the file with the name current_file_202006 and the second one reads as

CurrentDate as Date ( which is already formatted as 'YYYY\MM\DD' from the source table.

The two dates are not merging even though they have been formatted the same. 

When you convert them to num(monthend(Date(Date#(right(FileBaseName(),6),'YYYYMM'),'YYYY\MM\DD'))) as Date  and num(CurrentDate) as Date, you get  44012,999999988 for the first one and  44012 for the second one.

How can I merge them to be the same?

[Kushal_Chawda]

@sindisa12 

Can you share snapshot of both the Dates  by taking them in listbox? Just to look at the values

[sindisa12]

hI Kush. This is how they look. the second one was converted to a number.

[alex00321]

I once have the same issue with you, and here's what I found about this one:

Hope this helps. Thanks!

[sindisa12]

Hi Alex. The formula applied with Dat# function still returns the same values.