Forum Discussion
AlexGallet01
9 years agoHelper IV
How do an average for a column type date
Hello, I want to return an average date of a column. It is possible ?
fhill
9 years agoResident Rockstar
Is TECHNIKE[THCJDATE] formatted as a Date in Query Editor?
FOrrest
AlexGallet01
9 years agoHelper IV
- fhill9 years agoResident Rockstar
That looks right... , what's the Syntax Error? (Screen shot, or click Details wherever you see the error.)
- AlexGallet019 years agoHelper IV
- fhill9 years agoResident Rockstar
I would throw some dates into an excel, and try to duplicate the error outside your current data set. If it works in the 'basic version' then something isn't happy in your data set... It's strange the error is on the Date Column name????