QV date vs SQL date

[Strooprover]

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.

[marcus_sommer]

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