topic DATE values in QlikView

DATE values

Anonymous — Tue, 08 Feb 2011 21:08:34 GMT

I have a condition in my script as

and DATE <> '31/12/9999'

the datatype of the column is DATE in the database, i have format m/d/yyyy in my seetings in qlikview , however i change this condition i get an error...

Please help ...how do i get this condition validated.

DATE values

Tue, 08 Feb 2011 21:24:41 GMT

You say your date format is m/d/yyyy, but your expression has the date in d/m/yyyy format. I'm not sure 9999 would be an acceptable year either, but the 31 month is probably the main issue.

DATE values

Anonymous — Tue, 08 Feb 2011 21:29:41 GMT

i changed it to

DATE <> '12/31/9999' , but still i get an erro saying invalid month

DATE values

Tue, 08 Feb 2011 21:34:09 GMT

Try a different year. December of 9999 may not be a valid month, while December of 2011 would be. Try: 12/31/2011.

DATE values

Anonymous — Tue, 08 Feb 2011 21:37:07 GMT

i get the same error for 12/31/2011 too...

DATE values

prieper — Tue, 08 Feb 2011 21:41:36 GMT

If the field is a date, you must not use a string:

WHERE MyDate <> DATE#('12/31/9999', 'MM/DD/YYYY')

HTH
Peter

DATE values

Tue, 08 Feb 2011 21:47:51 GMT

Ramya,

I went about it a little different but it did exclude the TEST name:

Shane

DATE values

Anonymous — Tue, 08 Feb 2011 21:49:34 GMT

I Used the above i get "DATE#": invalid identifier

DATE values

Tue, 08 Feb 2011 23:06:15 GMT

Are you inside of a SQL load? Date# is a QlikView function, I do not know if it will work when doing a SQL load.

Could you provide the entire load script for this table? Know whether it is a SELECT or LOAD and seeing what type of source you are using could help.