topic Re: Dates not merging after formatting them in QlikView

Dates not merging after formatting them

sindisa12 — Sun, 06 Sep 2020 19:45:40 GMT

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?

Re: Dates not merging after formatting them

Kushal_Chawda — Sun, 06 Sep 2020 20:33:33 GMT

@sindisa12

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

Re: Dates not merging after formatting them

sindisa12 — Mon, 07 Sep 2020 05:07:41 GMT

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

Re: Dates not merging after formatting them

alex00321 — Mon, 07 Sep 2020 05:23:22 GMT

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

Hope this helps. Thanks!

Re: Dates not merging after formatting them

sindisa12 — Mon, 07 Sep 2020 05:42:31 GMT

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