The DATE type is compatible with the INTEGER type, but not all integer values are valid dates. This error arises in attempts to convert to character from a date whose numeric value is less than -693,594 or greater than 2,958,464. Numbers that are outside this range have no representation as dates.
You may also see this message if you try to use the VARIANCE() or STDEV() functions on an inappropriate data type, such as DATE.