topic Date from excel load is not matching Master Calendar Date in App Development

Date from excel load is not matching Master Calendar Date

Kat92 — Thu, 15 Jun 2023 10:34:45 GMT

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,

Re: Date from excel load is not matching Master Calendar Date

SunilChauhan — Thu, 15 Jun 2023 10:53:43 GMT

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

Re: Date from excel load is not matching Master Calendar Date

Kat92 — Thu, 15 Jun 2023 11:47:01 GMT

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