topic Re: QV date vs SQL date in QlikView

QV date vs SQL date

Strooprover — Sat, 13 Nov 2021 08:39:12 GMT

Hi,

I would like to compare a SQL datefield with a QV date variable in my SQL where clause but get an error.

My QV variable is:

let vStartDate = Today();

my SQL where clause:

where [Orderdate] <= '$(vStartDate)'

Anyone knows how to solve this error?

Thanks in advance!

Gr.

Re: QV date vs SQL date

marcus_sommer — Sun, 14 Nov 2021 13:33:15 GMT

Today() returns the date with your defined standard-format respectively without such defining with the OS standard. This format may not be suitable for your database but you could add the needed format-pattern with something like:

date(today(), 'MyFormatPattern')

- Marcus