Date difference

[sraj]

Hi there,

I am trying to calculate the date difference, from the PRT_OPEN_TASK_ADD_DT to today...even if the field is existing in the table it is not seeing it.  Can someone please advise on what I might be doing wrong here?  

[sraj · Accepted solution]

I found my issue, I was using a new measure option instead of a new column.  That fixed my issue, thanks for responding!!

[mahoneypat]

In a measure, you need reference an aggregation of a column, so wrap your column reference in MIN or MAX.

Pat