Re: Date Warning message

[Mark Boyd <mark@CG4.COM>]

A simple solution is to use the TO_CHAR() function in your select statement.
Something like this.

BEGIN-Select

to_char(A.Pay_End_Dt ) &A.Pay_End_Dt

end-select

This will fix your problem.  A more permanent solution is have a parameter set 
in
your sqr.ini.

Good luck.





Dave Ng wrote:

> Hi all,
> I like to know why i'm getting the following message when i try to run SQR on
> the server
>             Warning on line 2331:
>                 (SQR 7501) Using YY edit mask from (DD-MON-YY) against (1999)
> Line#2331 = move &A.Pay_End_Dt to $AsOfDate
>
> SQR Ver: 4.3.2
> Platform: AIX 4.3
> RDBMS: Oracle 7.3.4
> PeopleSoft HRMS 7.01
>
> thanks
> dave