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.  ...
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?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Phil_Seamark,

 

it worked perfectly. Could you please tell me what's the difference between a measure and a calculated column?

 

Thanks in advance.

 

Cheers,

Andrea