Re: Date error in ReportBuilder

[Lance Petersen <LANPET@SAIF.COM>]

don't you need quotes around MM/DD/YYYY...?

-----Original Message-----
From: Michael Wheeler [mailto:Michael_Wheeler@PUTNAM.COM]
Sent: Tuesday, August 07, 2001 9:09 AM
To: SQR-USERS@list.iex.net
Subject: 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