Skip to Content
0
Former Member
Mar 24, 2009 at 05:37 AM

To find the latest Date in a group.

799 Views

Hi,

I am having fields called services and a date field.I am grouping the records based on services.I want to display the records for only the latest date in that particular record.

say for eg..if i am having dates for a particular service as

12/31/2008

11/30/2008

01/31/2009

02/04/2009

I want to display records only for 02.04/2009.But now when i use maximum function i am getting 12/31/2008.I think it is considering only the day values.

Can anyone please help me.

Thanks in Advance,

Hema