date format issue- append qvds

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I am trying to append my QVD's and I seem to keep getting this issue. I have tried so many different formats of date but I still keep getting this issue- literal string does not match.

The START_DT field is what I am using in my where clause to work out new entries in the table from the database.
If I load the field without any where clause, it's fine and the format of these fields is DD/MM/YYYY hh:mm:ss.

I created a variable vCurrentDay and it looks like this:
vCurrentDay = DATE((date(Today())-1), 'DD/MM/YYYY hh:mm:ss[.fff]')

So my variable is in the same format.

Then when I use my variable in the where clause as such: where START_DT >= '$(vCurrentDay)';

The issue will show.
I have tried a number of ways of writing the format, changing the format on the load section etc but keep getting error messages.

I really don't know what to do to fix this. Can anyone help?
Any help is much appreciated.

I am running version 10 SR1. *this is in the wrong forum because I keep getting an error when I try and upload this query to the developer forum*

Thanks

date format issue- append qvds

tresB — Thu, 03 Mar 2011 13:03:24 GMT

if all the other things are fine, it could be an issue with LET or SET. What are you using to define the variable ? try with alternative. you can check the value in the variable using TRACE command followed by a SLEEP command.

regards, tresesco

topic date format issue- append qvds in QlikView

date format issue- append qvds

date format issue- append qvds