Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sindisa12
Contributor
Contributor

Dates not merging after formatting them

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?

4 Replies
Kushal_Chawda

@sindisa12 

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

sindisa12
Contributor
Contributor
Author

sindisa12_2-1599455233035.png

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

alex00321
Creator II
Creator II

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

alex00321_0-1599456181157.png

Hope this helps. Thanks!

sindisa12
Contributor
Contributor
Author

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