Page 1 of 2

Date Limitations in R&R Version 10

Posted: Wed Jul 16, 2003 10:21 pm
by Michael_Christy_(Guest)
In R&R Version 9 with the patch the upper boundry date limitation is 2399. What is the upper boundry date limitation in R&R version 10?____Thanks,__Michael Christy

=> Date Limitations in R&R Version 10

Posted: Thu Jul 17, 2003 7:32 am
by kfleming
Version 10 extends the upper limit for date fields to 12/31/2999.____Kathleen__R&R Support

==> RE: Date Limit in R&R Version 10

Posted: Thu Jul 17, 2003 9:02 am
by Michael_Christy_(Guest)
Kathleen,__Thanks for your quick response. Do you envision the upper limit for date fields to be extended past 12/31/2999 in future versions of R&R?____Thanks,__Michael Christy

===> RE: Date Limit in R&R Version 10

Posted: Thu Jul 17, 2003 1:03 pm
by kfleming
How far out do you need to go?____Kathleen__R&R Support

====> RE: Date Limit in R&R Version 10

Posted: Fri Jul 18, 2003 11:03 am
by Michael_Christy_(Guest)
That^s a very good answer for what seems like a crazy question. Let me explain. We currently have a vendor who uses the date 12/31/9999 within a date field to identify the most current record within an Oracle table. Crazy isn^t it. I am currently working with R&R version 8.1 Sql and it does not recognize 12/31/9999 as a valid date. R&R displays the invalid date as Asterisks in the print preview screen. I am aware from your e-mail reply that Version 10 extends the upper limit for date fields to 12/31/2999. I^ve tried using the function DTOC() but it does not work because R&R does not consider it a valid date in the first place. Is there a work around or something that I have not considered that would allow R&R to process the value of 12/31/9999 even as a character string within this field?____Any help would be greatly appreciated.__Thanks,__Michael Christy

====> RE: Date Limit in R&R Version 10

Posted: Fri Jul 18, 2003 11:42 am
by Eddie_Marshall
We are vendors of Property Management Sofware and a few of our clients have 1000 year leases. So we need the dates to got to the 3000^s and beyond!____Eddie Marshall__LandMaster

=====> RE: Date Limit in R&R Version 10

Posted: Fri Jul 18, 2003 1:59 pm
by Michael_Christy_(Guest)
A 1000 year lease. Are you serious? How do you amortize a 1000 year lease? You should get together with my vendor.____Regards,__Michael Christy

======> RE: Date Limit in R&R Version 10

Posted: Tue Jul 22, 2003 2:30 am
by pdempsey
That technique of identifying the most current record is very strange. Wonder who told him to do that. Sounds like the old 9999... for the end of the file. Have you tried to assume that since Oracle must validate dates, using the iif(error(date), "character string", dtoc(date)) That might work. You may have to check for blank dates first. I don^t know how Oracle stores dates.__-Pat-

=======> RE: Date Limit in R&R Version 10

Posted: Wed Jul 23, 2003 7:30 pm
by Michael_Christy_(Guest)
That did the trick! Thank you very much.____Mike...

====> RE: Date Limit in R&R Version 10

Posted: Mon Nov 10, 2003 9:33 pm
by Waznegoaby
Hi Kathleen,____I^m also aware of situations (in healthcare industry) where 12/31/9999 is used to indicate that there is no end date. One reason they do this is so that blank end-dates appear last when sorting.____Jerry