Hi Everyone. Is anyone familiar with a way to figure out what the average of a date field is?
For instance, if I have a date field like [Start Date] with the two values of 1/1/16 and 1/10/16, the average would be 1/5/16. I know that one of the difficulties is that if the numbers are not as clean, it's a big oversimplification to say that the entire day is the average (i.e. maybe the average is 1/5/16 at 10:54 am)
Does anyone know of a workaround or have any ideas? Thanks!
You could find the DATEDIFF between the dates, the number of days, which in this example would be 10. Divide this by the number of dates, 2, which gives you 5. Then DATEADD this 5 to the original start date, giving you Jan 5 in your example. This method should work with 2 dates but would need to be revised for multiple dates.