[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: SQLBase & SQR Help -Reply

Scott,
Instead of using         substr(C.termination_dt,7,4) = $currentyear
in your SQL
Try                  TO_CHAR(C.termination_dt,'YYYY') = $currentyear

David Cholaghian
Bentley College