[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
date formatting question
- Subject: date formatting question
- From: Joe Johnson <jejohn1216@SURFREE.COM>
- Date: Wed, 13 Oct 1999 15:48:40 -0700
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