Re: date formatting question

[Joe Johnson <jejohn1216@SURFREE.COM>]

Thanks Vijay

I have more information:

This SQR worked as is on our 'old' system
Oracle 7
HR & FS Tools 7.01
HR & FS PS App 7.01
SQR 3

But not on our 'new' system
Oracle 8
HR & FS Tools 7.05
HR & FS PS App 7.02
SQR 4.3.4

Is this an upgrade issue?

TIA

- Joe
On Thu, 14 October 1999, Vijay Gourimath wrote:

>
> Hi Joe
>
> I think when you initialize $check_dt to this '' or to this ' '   it will be
> treated as string variable rather than date variable. So in SETUP section
> declare $check_dt as date variable as shown below.
>
> DECLARE-VARIABLE
>       date $check_dt
> END-DECLARE
>
> > -----Original Message-----
> > From: Joe Johnson [SMTP:jejohn1216@SURFREE.COM]
> > Sent: Wednesday, October 13, 1999 6:49 PM
> > To:   Multiple recipients of list SQR-USERS
> > Subject:      date formatting question
> >
> > Hey, group!
> >
> > We have an SQR that runs on the server, and bombs out with the message
> > "Error on line 689: (SQR 1944) The date ' ' is not in the format specified
> > by SQR_DB_DATE_FORMAT or in one of the accepted formats listed below:
> > DD-MON-YY
> > SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]"
> >
> > In the infamous (to us)line 689, there is this:
> >
> >  if  (&b.emplid <> $emplid or &b.check_dt <> $check_dt) or
> >       #current-line = 11
> >       print $printcheckdt (0,{c5a})
> >   end-if
> >
> > Now, earlier in the file,
> > $check_dt is set to ' ' to initialize the variable.
> >
> > QUESTION: Shouldn't the variable $check_dt be set to '' instead of ' '?
> > {that is, quote-quote instead of quote-space-quote}
> >
> > &b.check_dt, by the way, is formatted by
> > do format-datetime(&b.check_dt,$printcheckdt,{DEFMDY},'','')
> >
> > TIA -- as always!
> >
> > Joe Johnson ;{)
> > __________________________________________
> > $14.95 a month Unlimited Internet Access.
> > Get your first month for $1.00.
> > http://www.surfree.com/promo

Joe Johnson ;{)
__________________________________________
$14.95 a month Unlimited Internet Access.
Get your first month for $1.00.
http://www.surfree.com/promo