Date Limitations in R&R Version 10

Ask any questions you have about purchasing R&R ReportWorks. Will it work with my operating system? Will it access my database? Can I convert my old reports?
Michael_Christy_(Guest)
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

Date Limitations in R&R Version 10

Post by Michael_Christy_(Guest) » Wed Jul 16, 2003 10:21 pm

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
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> Date Limitations in R&R Version 10

Post by kfleming » Thu Jul 17, 2003 7:32 am

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

Michael_Christy_(Guest)
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

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

Post by Michael_Christy_(Guest) » Thu Jul 17, 2003 9:02 am

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
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

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

Post by kfleming » Thu Jul 17, 2003 1:03 pm

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

Michael_Christy_(Guest)
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

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

Post by Michael_Christy_(Guest) » Fri Jul 18, 2003 11:03 am

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
Posts: 122
Joined: Tue Oct 10, 2017 12:44 pm

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

Post by Eddie_Marshall » Fri Jul 18, 2003 11:42 am

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)
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

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

Post by Michael_Christy_(Guest) » Fri Jul 18, 2003 1:59 pm

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
Posts: 56
Joined: Tue Oct 10, 2017 12:44 pm

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

Post by pdempsey » Tue Jul 22, 2003 2:30 am

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)
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

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

Post by Michael_Christy_(Guest) » Wed Jul 23, 2003 7:30 pm

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

Waznegoaby
Posts: 0
Joined: Sat Mar 31, 2018 9:54 pm

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

Post by Waznegoaby » Mon Nov 10, 2003 9:33 pm

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

Post Reply