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

Date error in ReportBuilder

I am trying to do a simple query of a date from one of my tables.  Here is
the code:

Begin-Select
settle_date (12,1) Edit MM/DD/YYYY
 Next-Listing  Need=12
>From  UCM_MGR.UCM_TXN
End-Select


I am getting the following error:

Error on line 31:
   (SQR 1915) Year cannot be zero.

SQR: Program Aborting.


Does anyone have any ideas why I am getting this error?  The date field is
NOT NULL and I have checked all of the dates and they are valid.

Thanks,
Mike