Displaying the most current date in a field 1

[gennaroalpha7]

Hello Experts -

I have a field that analysts enter a date for journal updates.

I want to add a formula to the report the selects the most current date of this field.

The field is 'Journal.EntryDate'

The formula that I currently have is:

Maximum({Journal.EntryDate}, {Asgnmnt.GroupName})

But for some reason it is not displaying the most current date. Am I doing something wrong or is this the appropriate formula?

Thanks.

G.

 

[BettyJ]

In your other post you mentioned that your field is string. That's the reason it is not displaying the most current date.

As Charliy suggested, create a formula @Date_EntryDate and add the following
Date({Journal.EntryDate})

In the Record Sort Expert, select @Date_EntryDate
Ascending

I believe you are finding the most current date per analyst. If so, group by Analyst (use your table field name), copy @Date_EntryDate and all the fields you need displayed in the group footer.

Suppress the group header and detail.
Hope this helps.

 

[BettyJ]

After reading your entire previous post, I feel you are looking for the most current date of ticket. If so, you have to group by ticket (Use your table field) instead of analyst as I suggested in my previous post.

 

[gennaroalpha7]

Hi -

In the field 'Journal.EntryDate (string)' analysts enter a date for an update to a ticket. So lets say a ticket has 3 updates...2/11/2014, 3/06/2014, and 3/24/2014.

What I want to do is to display the most current date...that would be 3/24/2014. Currently my report is grouped by departments and my current formula has that group field. I thought that would do it but I am having a bit of hard time due to my experience level.

I will try what you have suggested BettyJ.

Thank you.

G.

 

[BettyJ]

Create another group on ticket. Then sort on the formula mentioned earlier.
Now copy @Date_EntryDate to the Group Footer of ticket, (GF2).
Hide Details, and all other sections that you don't need displayed.

 

[gennaroalpha7]

Hi -

I tried your suggestion and it helped, but the report is showing all ticket updates for each ticket, so in my example above, the ticket is shown 3 times but the field Journal.EntryDate has 3 different ticket update (...2/11/2014, 3/06/2014, and 3/24/2014) dates. Can I remove the duplicates and keep the most current 'Journal.EntryDate' date?

In the Details Section Expert I have it suppressed with this formula '{CallLog.CallID}= previous({CallLog.CallID})' to rid the duplicates, but it doesn't seem to take.

Here is a link with the report, please review.

https://www.dropbox.com/s/q640exmdbm365xe/Assignments Days Past v0.2.rpt

Thanks.

G.

 

[gennaroalpha7]

Hi -

I followed your suggestion from your previous post, and it's working fairly well, but I am getting some duplicate tickets with earlier 'Journal.EntryDate' dates. I need the most current ticket with the most current 'Journal.EntryDate' date.

Can I remove the duplicate tickets and keep the most current 'Journal.EntryDate' date tickets/CallLog.CallID (string)?

Thank you.

G

 

[BettyJ]

Did you copy the @Date_EntryDate to the Group Footer of ticket, (GF2) and suppress the details section? (All sections except GF2 should be suppressed).

 

[gennaroalpha7]

Yes, Betty -

Its working well, thank you very much!

Although I am getting a some duplicates - how can I rid them and keep the most current.

In the Details Section Expert I have it suppressed with this formula '{CallLog.CallID}= previous({CallLog.CallID})' to rid the duplicates, but it doesn't seem to take. Can I use this same formula in the GF2 section?

Thank you.

G

 

[gennaroalpha7]

I relocated all the fields I had in the details section to the GF2 section and suppressed all sections except RH, PH, GH1, GF2, RF, and PF.

Thanks.

G