Re: date formatting question

[Vijay Gourimath <gourimv@SX.COM>]

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