Date from excel load is not matching Master Calendar Date

[Kat92]

Hi,

I am loading an excel in Qlik Sence that has one date column with following format "12/1/2023 9:22:00 πμ".

Although I have tried formatting in date and in tables used in front end seems as expected when connecting with Master Calendar I get NULL matches. (while by looking at it I see common dates)

I have tried converting with Date("Date",'DD/MM/YYYY') , Date(num#("Date",'DD/MM/YYYY') and 

date(Date#("Sent Date",'DD/MM/YYYY'),'DD/MM/YYYY') (this one returns NULL while the first two return dates that look as expected but are not matched)

Could someone assist?

Thanks in advance,

[SunilChauhan · Accepted solution]

use makedate(left(Subfield(date,'/',3),4),subfield(date,'/',2),subfield(date,'/',1))  as NewDate

[Kat92]

Hi,

Thank you for your reply!

It seems to be working, also I just tried the simple FLOOR function instead of date formats and also seems to be working.

Thanks again