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

When i want to create custom column i have an error she says error syntax or i write this 

 

NumDays = DATEDIFF(0,TECHNIKE[THCJDATE];DAY)

fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Is TECHNIKE[THCJDATE] formatted as a Date in Query Editor?

FOrrest

    • fhill's avatar
      fhill
      Icon for Resident Rockstar rankResident Rockstar
      9 years ago

      That looks right... , what's the Syntax Error?  (Screen shot, or click Details wherever you see the error.)