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