Incorrect date sorting order in 3D Riser Graph

[JohnEfford]

I work for a charity, I am plotting a 3D riser chart which shows when a person last donated and when they made their first donation by the number of people in the group. The data for the graph comes from a donation table, which holds the contact record number, the contact date and other donation details. A contact record number can appear many times in the donation table so to find the first contact date I use:

Minimum ({FMDonations.DateReceived},{FMDonations.Donor} )

And to find the last donation

Maximum ({FMDonations.DateReceived},{FMDonations.Donor} )


The two calculated date fields are the then used as the X and Y axis for the chart (the Y axis is the number of donors in the group). In chart expert I sort the dates in ascending order and show them in half yearly intervals. When the chart is produced the date order is 01/00, 07/00, 01/98… 07/99, 01/01…. Does anybody know how to get the correct date order in this chart.

 

[JohnEfford]

Think I found the solution I needed to convert a date time to a date:-

date(Minimum ({FMDonations.DateReceived},{FMDonations.Donor} ))

this seems to of fixed it.