Forum Discussion

AlexGallet01's avatar
AlexGallet01
Icon for Helper IV rankHelper IV
9 years ago

How do an average for a column type date

Hello,   I want to return an average date of a column. It is possible ?
Need Help
AlexGallet01's avatar
AlexGallet01
Icon for Helper IV rankHelper IV
9 years ago

Hi,

 

My start date are above my end date

 

Or it's impossible because my start date are 0

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi AlexGallet01,

 

To use DateDiff function, we should meet the syntax that "the start date cannot be greater than end date". Otherwise, it will prompt error.

 

Regards,
Yuliana Gu