DATE values

[Anonymous]

Hi

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.

[#2]

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.

[Anonymous]

i changed it to

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

[#4]

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

[Anonymous]

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

[prieper]

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

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

HTH
Peter

[#7]

Ramya,

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

Shane

[Anonymous]

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

[#9]

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.