Re: SQR 7501

[Jim Vanderpool <Jim.Vanderpool@CUSYS.EDU>]

Randy,

It's likely your SQR.INI (or PSSQR.INI in Peoplesoft) is driving the two
digit year format.  We're on Oracle and have set up the following code in
PSSQR.INI (actually, just modified what was delivered) to get around the
problem:

[Environment:Oracle]
SQR_DB_DATE_FORMAT=MM-DD-YYYY

That should fix it.

Jim Vanderpool
University of Colorado
Administrative Streamlining Project



At 04:07 PM 7/7/00 -0600, you wrote:
>Mark,
>
>I guess I should have asked why a strtodate function is returning a two
>digit year (DD-MM-YY).
>
>Randy
>
>
>
>-----Original Message-----
>From: Discussion of SQR, Brio Technology's database reporting language
>[mailto:SQR-USERS@list.iex.net]On Behalf Of Risman, Mark
>Sent: Friday, July 07, 2000 3:52 PM
>To: SQR-USERS@list.iex.net
>Subject: Re: SQR 7501
>
>
>Randy,
>
>This is a warning, not an error.  It means SQR thinks you might be trying to
>compare a two-digit year against a four-digit year.  If these warnings are
>errant and come up frequently, you can disable this message by setting
>"OutputTwoDIgitYearWarningMsg" in your sqr.ini file to false.
>
>- Mark
>
>
>                 -----Original Message-----
>                 From:   Randy Kirkpatrick [mailto:randyk@MESSAGEMEDIA.COM]
>                 Sent:   Friday, July 07, 2000 5:38 PM
>                 To:     SQR-USERS@list.iex.net
>                 Subject:        SQR 7501
>
>                 Can anyone tell me why I'm getting this error and how I can
>fix it?
>
>                 (SQR 7501) Using YY edit mask from (DD-MON-YY) against
>(2000)
>
>
>                 Randy K.