Need help creating a Calculated Dimension for counting days based on date column

[Former Member]

Howdy all!

Not sure what I'm doing wrong or even if it can be done, but I have a Date column I want to calculate the total amount of days up to the current date.

So basically, if the column has a date of January 1st 2016, and today is January 31st 2016, I want the new Calculated Dimension column to calculate/display the number 30 (days).

Thanks - Ray

[TammyPowlas · Accepted solution]

Yes, you can create a calculated dimension using the difference in dates function -see below:

It will take the current date and the date from your column and calculate the difference

[Former Member · Accepted solution]

Thanks a bunch. I was able to calculate "Days Old" with your help.

From there, I was able to calculate anything over or under 5 years old by giving it an "EOL" designation.

if {Days Old} < - 1825 then ("End of Life") else ("NOT End of Life")