Name, Unit, TagName, CalDate, CalPeriod,
CalPeriodType,
(CalPeriod + Unit) AS CalNum
FROM tblTemp
WHERE (CalPeriod + Unit) > 7";
I do appreciate the thoroughness of your effort in coversion to Months,
However the potential for using Days looms ahe
Gerard Gilliland replied:
Michael:
Thank you for your excellent suggestion and quick response.
I now have an operable DATE_ADD.
The solution to break nPeriod into n and Period would not work directly.
That is, in the SELECT statement in the form of ...
$qry = "SELECT PlantName, Unit, Ta
General server information: July 15, 2004
Operating system: Linux
Kernel version: 2.4.26
Apache version: 1.3.31 (Unix)
PERL version: 5.8.0
Path to PERL: /usr/bin/perl
Path to sendmail: /usr/sbin/sendmail
PHP version: 4.3.7
MySQL version: 4.0.18-standard
I would appreciate any help.
Than
