cancel
Showing results for
Did you mean:
Helper IV

## Re: How do an average for a column type date

`The returned values are false because i have a result = 2089/09/16 `

Solution Sage

## Re: How do an average for a column type date

Can you add 'NumDays' to this example, i'm curious what your 5 digit dates look like...???

Highlighted
Helper IV

## Re: How do an average for a column type date

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

Helper IV

## Re: How do an average for a column type date

DATE MOY = FORMAT(DATE(2000;1;INT(AVERAGE(TECHNIKE[NumDays])-36523));"YYYY-MM-DD")

Helper IV

Solution Sage

## Re: How do an average for a column type date

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+

Helper IV

## Re: How do an average for a column type date

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

Microsoft

## Re: How do an average for a column type date

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

Regards,
Yuliana gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IV

## Re: How do an average for a column type date

Hi,

My start date are above my end date

Or it's impossible because my start date are 0

Microsoft

## Re: How do an average for a column type date

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### ‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.