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
fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Here is the issue...  These values are wrong...  I'm not sure how your 'Date MOY' is being caculated (or where it's from) but 2015-12-08 and 2015-12-06 should only be 2 NUMDays apart, not 230,000+

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

I try to modify the colum but i have an error and i don't understand why i have this error

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

    Hi AlexGallet01,

     

    What does the error message point to? Could you please translate it to English?

     

    Regards,
    Yuliana gu

  • 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