1 Reply Latest reply: Mar 3, 2011 8:03 AM by Tresesco B RSS

    date format issue- append qvds


      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*