Re: STRSQL request gives CPF4802

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

David FOXWELL wrote:
> Hi Dennis, you're early!
>
> Actually, I had a date of birth in the select.
>
> I get the message that the date is smaller than the minimum permitted, and ++++++++ is displayed. If I take the date of birth out of the select, the problem doesn't occur.
>
> However, if I look at the client with runqry, I see 07.03.1930 as the birthdate. 
>
> It gets curiouser and curiouser.
>   
This is running as designed.  This date value is out of range for 
six-digit display modes such as *MDY and *DMY, which IIRC only allow 
dates between 1940 and 2039.  Your 1930 date will only display properly 
if your session is set to an eight-digit date format such as *USA or *ISO.

Joe