Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated Column: DATEDIFF with filter - not working + getting negative numbers

Hi folks, I'm hoping someone can help me. I'm trying to create a calculated column to show the time elapsed, in days, between when a piece of documentation was created [Created Date], and TODAY(...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks so much for the quick feedback Greg_Deckler  - after your reply I realied that what I'm actually trying to create is a calculated column, not a measure - I do apologise. I've editied the original post accordingly...

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

I think that calculation should work in a column.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Maybe I'm misunderstanding the issue, and simply doing something wrong?

     

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago

      It looks for all the world that you are creating a measure. You want to create a column right?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Apologies again, I had gotten mixed up (that'll teach me for rushing) and was indeed trying to create a measure. I've sucessfully used your code to create a calculated column (thanks again), but 1) I'm getting negative numbers, and 2) it's not returning blank results for the non-'draft' articles: