Recent content by acr1

Fred I agree that there are multiple deprec recs..and should have been more specific at the start.. I think I will rewrite the query or try SQL..our thread seems to be getting out of hand. Thanks for your input anyway.

1. Do you want one line per compkey? - Yes 2. Is there one ASSVALUE line per COMPEQ or multiple. - one ASSVALE 3. It looks lines there is mutiple ASSDEPRE per ASSVALUE. Correct? - Correct Yes ...monthly depreciations.. TIA

Fred SQL as follows out of the crystal report.. SELECT COMPEQ."AREA", COMPEQ."COMPKEY", COMPEQ."PURCDATE", COMPEQ."UNITID", ASSVALUE."ACQDATE", ASSVALUE."CAPTLEXP", ASSVALUE."EXPLIFE", ASSVALUE."INITCOST", ASSVALUE."REVALAMT", ASSDEPRE."ACCDEPREC", ASSDEPRE."DEPRECAMT"...

Fred CR 8.5, and Oracle 8i db Based on other selection criteria (I dont think we need to go there) but as follows... One @DateNOtEqual {COMPEQ.PURCDATE} <> {ASSVALUE.ACQDATE} Two @DateVariant Abs ({COMPEQ.PURCDATE} - {ASSVALUE.ACQDATE}) Three @datediff {@DateVariant} > 366 //Greater than 1...

Hi Fred I inserted the line ASSDEPRE."DEPRECDATE" = '30 JUNE 2003' as an example but it is not in the SQL WHERE statement behind the report..sorry about that. I have tested ASSDEPRE."DEPRECDATE" = '30 JUNE 2003' and I know it works and only brings out 30 june 2003 data.. So I am back to...

Hi Fred Is it possible to run what we have communicated.. in SQL .? and changing the 'deprecdate' parameters below.? WHERE COMPEQ."COMPKEY" = ASSVALUE."COMPKEY" AND ASSVALUE."ASSVALKEY" = ASSDEPRE."ASSVALKEY" ANS ASSDEPRE."DEPRECDATE" = '30 JUNE 2003' TIA Angus

Hi Fred Me well Wellington NZ and thanks again for your prompt response. It did not like the 'max' as was wanting a field , time, string, booleen, etc.. but when running still brings out the whole db of 4000 plus recs. Scenario 1 is correct. Scenario 2 would be 29/06/2003. I need 30/06/2003...

Hi Fred Once again thanks for your prompt reply..where are you geographically.? The Formula is If ({ASSDEPRE.DEPRECDATE}) = Date (2003,06,30) then {ASSDEPRE.DEPRECDATE} Else Previous ({ASSDEPRE.DEPRECDATE}) which is not working properly as it extracts approx 4000 records aand I only want...

Hi Fred Thanks for your prompt advice however it does not appear to be displaying previous dates..for records that are one date previous...

Hi All I am trying to get the last valuation date using "previous" if the date is not the 30 June 2003.. I wish to display all dates that are the 30 June 2003 and if not then the previous valuation date. I am using the formula as below which is working fine ({ASSDEPRE.DEPRECDATE}) = Date...

Re prev...sorry Crystal 8.5

I wish to calculate the remaining life of assets at a specific date based on the info below:.. ASSVALUE.ACQDATE..(Date/time stamp) - Acquisition Date ASSVALUE.EXPLIFE..(Life in Years) - Expected Life in Years..(eg 30) Currently I have a formula in an existing report (not developed by me) as...

Hi Ravi Thanks for your reply...but looking at the numerable ways to use DateDiff an example if possible would help.. TIA Angus

Hi Team I have a formula below that works as I need to find dates greater than one year...but I also need it to calculate when the PURCDATE is greater than the ACQDATE as well.... as i have some PURCDATE fields (1988 - later) and some ACQDATE fields (1975 - earlier) Should I use ABS...

Hi All I have a DateTime Field in a front end program that has a oracle db backend.. I want to extract data for a date ..eg (June 2003) from the database using Crystal 8.5 I have tried the 'ToText'...but need to get all entries for a specified month. Any help asap would be appreciated. Thanks...