AVG Function and Date field

[mytaurus2000]

Can you take the AVG of a Date column

 

[dhookom]

Try it and report back. It seems this would take much less time to test/try than to post a message and wait for a reply.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mytaurus2000]

I did try it, and it returned nothing. I was curious if the reason why it returned nothing was because it wasn't possible or I'm asking it to do the wrong thing

 

[PHV]

I did try it
Try WHAT ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mytaurus2000]

I tried to use the avg function with a date field

 

[AlexCuse]

What were you expecting?

For example, please tell me the average of these three dates:

1/1/1900
2/24/2003
9/24/2006

Spoiler

the average is 25554

Converted to date this is 12/17/1969

Doesn't exactly mean much does it?

If this is really what you want, try this:

CDate(Avg(MyDateCol)) as MyAvgDate

If you have a date stored in a text column I doubt it will work, but CDate(Avg(CDate(MyDateCol))) might...

Good Luck,

Alex

[small]----signature below----[/small]
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom

 

[SkipVought]

What are you trying to accomplish?

Please state the Business Case for this requirement.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}