I have a series of events and their date. I can write the query to get the list, but cannot figure out how to add a query for the mean day of the series.
date 6/21/1994 6/23/1994 7/2/1994 7/19/1994 4/25/1995 6/3/1995 6/24/1999 6/30/1999 6/20/2000 6/11/2001 5/10/2003 5/29/2003 8/6/2003 6/2/2006 6/2/2006 7/12/2010
How can I get the mean date of this series? Day of month, ignoring the year of the event? Thanks for any suggestions.
date 6/21/1994 6/23/1994 7/2/1994 7/19/1994 4/25/1995 6/3/1995 6/24/1999 6/30/1999 6/20/2000 6/11/2001 5/10/2003 5/29/2003 8/6/2003 6/2/2006 6/2/2006 7/12/2010
How can I get the mean date of this series? Day of month, ignoring the year of the event? Thanks for any suggestions.