More Date fun

[Cort]

I'm sure this is a very simple problem and I thank you for your help. I'll try not to ask a question twice.

I have a Date field "TRNS_DATE" which reports in mmddyy format. It is in the detail section of my report.

I want the formula to examine the detail section and find the last date (most current) that a transaction was entered and return it.

Example:

The TRNS_DATE field has data ranging from 1-1-99 to 4-30-02. I want a formula that will examine that field and return that last date.

Thank you again for your help.

BTW as an aside do you reccomend the QUE books fro Crystal Reports. I have found the Que books for Word and Access invaluable or do you know of a better book for Crystal?

 

[Naith]

Date fun, indeed.

How about you right click the date field, insert running total, based on a maximum of the date field, reset on change of group - then pass the value into the group footer.

Naith

 

[dgillz]

Instead of a running total, just right click the date field and inser summary or grand total, whichever you want, and make the summary operation a maximum. This will give you the maximum, but there is no formula needed.

If you need to address this in a formula, then for a maximum of the data for the entire report, type in:

Maximum({DateField})

For the greatest data of a group, type in:

Maximum({DateField},{GroupByField})

In the boo area, the best crystal book I have seen is George Peck's "Crystal Reports V8.5 - The Complete Reference".

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Cort]

I found the Maximum({DateField}) refrence in the "How to I add a Date Range to My Report" FAQ and used it. My field is a DateTime but with a bit of left trim it works perfectly.

Thanks on the book info I'll be sure to pick it up. My Company sent me to NewHorizons for their Crystal Reports 1 and 2 class and then has left me to myself to figure out the rest. This is such a huge program that 2 classes just don't do it justice and I can see 80% of working with this is going to be trial and error.

Thanks again for the assistance.