Re: SQL Valid Date

Have you tried reading the readme?
values idate(19500523, '*CCYMD'), idate(20050523, '*CCYMD')

returns
....+....1
VALUES
1950-05-23
2005-05-23

While
values idate(19500523), idate(20500523)
....+....1
VALUES
2850-05-23
1950-05-23

Here is why, (and figuring it out was fun), a *CYMD date was assumed.
If you add 9 centuries on to 1950-05-23 you get 2850-05-23
If you add 0 centuries on to 1950-05-23 you get 1950-05-23

And as the readme says:
<snip>
The default date format is included as a constant in the code. I have set
it to *CCYMD because I think that should be the most common type. If you
have a different default format on your system, change the constant
cDefaultFormat in the header of XVIDAT_M01 before you compile.
</snip>
Well, apparently the default on your load (and mine too) is set to *CYMD
and not *CCYMD.



Rob Berendt