topic Re: Date does not correspond in QlikView

Date does not correspond

EternalDX — Sat, 16 Nov 2024 04:28:43 GMT

Hi,

In a calendar when selecting a date, I was selected one day later, I searched for solutions but I have not found, can someone help me?

Re: Date does not correspond

m_woolf — Tue, 12 Feb 2019 14:52:06 GMT

Here's a guess. Maybe your date fields have a timestamp component.
It would help if you showed more data, field names, etc.

Re: Date does not correspond

EternalDX — Tue, 12 Feb 2019 15:02:57 GMT

Hello,

I have put the MAKEDATE function in all my tables in the Script Editor, the sources are SQL databases and I do not use TimeSpan, I enclose the table diagram.

Greetings and thanks

Re: Date does not correspond

m_woolf — Tue, 12 Feb 2019 15:19:50 GMT

Maybe you should rethink your data model.

Re: Date does not correspond

EternalDX — Tue, 12 Feb 2019 15:22:11 GMT

I'm new to this, what do you recommend?