Date Limitations in R&R Version 10

[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

[kfleming]

Version 10 extends the upper limit for date fields to 12/31/2999.____Kathleen__R&R Support

[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

[kfleming]

How far out do you need to go?____Kathleen__R&R Support

[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

[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

[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

[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-

[Michael_Christy_(Guest)]

That did the trick! Thank you very much.____Mike...

[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