Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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