Date Fields

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

[kfleming]

Version 9 (with a patch applied) extended the upper limit of date support to 12/31/2999.____Kathleen__R&R Support

[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

[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