Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

DATEDIFF

Hi everybody,

 

I have a dataset where I want to compute the ageing of some items to date.

 

Basically what I want to do is very easy, it's a subtraction of the item date and TODAY() function. 

 

I tried to do it creating a measure using DATEDIFF, however when I use this function I cannot select the column field containing the item dates after the parenthesis.

 

Why I cannot use it as a measure? Should I then go to the query editor? If yes, what's the formula to use instead of DATEDIFF?

 

Thanks in advance.

 

Andrea

 

Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi Anonymous

     

    Have you tried using the DATEDIFF function in a calculated column, rather than in a calculated measure?

     

    Do you hve a small sample set of data?

3 Replies