Page 1 of 1
Date Fields
Posted: Wed Sep 26, 2001 9:12 am
by alister_tallents
R&R Version 8.1 can only cope with dates in the range 01/03/1600 through 31/12/2400.____I have a property database and want to report on the expiry date of leases some of which are 999 years. If these dates are greater than 31/12/2400 R&R prints **/**/****____Any suggestions on how I might overcome this problem ?______Alister __
=> RE: Date Fields
Posted: Sat Aug 17, 2002 8:30 am
by kfleming
Version 9 (with a patch applied) extended the upper limit of date support to 12/31/2999.____Kathleen__R&R Support
==> RE: Date Fields
Posted: Thu Aug 22, 2002 5:36 am
by Eddie_Marshall
In our database we automatically convert some date fields to a character string of CCYYMMDD and store the result in a seperate field. We then convert this field into a British format date by creating a calculated field with expression RIGHT(RTRIM(CHARDATE),2)+^/^+SUBSTR(CHARDATE,5,2)+^/^+LEFT(CHARDATE,4)____This is where CHARDATE is field containing the converted charcater string of the date.____I do hope this helps.____Regards,____Eddie Marshall__Technical Support Manager__LandMaster__eddie@landmaster.co.uk
===> RE: Date Fields
Posted: Thu Aug 22, 2002 5:57 am
by Eddie_Marshall
I thought I^d say that we develop and sell a Property Management database for the UK and Ireland market. It is suitable for all property types but oher systems deal better with Residential. Our customers want to do exactly what you are attempting. As R&R has not been able to deal with dates beyound 31/12/2399 for sometime, we had to come up with this "fudge". R&R has been our report writer of choice ever since we started writing Property databases. It is the best on the market and no other one comes even close in our opinion. If you would like more info on us, go to http://www.landmaster.co.uk____Good luck.____Eddie Marshall