Forum Discussion

Caitlin_Knox's avatar
Caitlin_Knox
Icon for Advocate III rankAdvocate III
11 years ago
Solved

Date Calculations - Resulting Data Type

I'm having an issue with a calculated column in my model that subtracts a date column from todays date, where I want my end result to be 'days'. The result comes in a date format but I've used this f...
Need Help
Tutorial Requests
ashishrj's avatar
ashishrj
Icon for Power Participant rankPower Participant
11 years ago

Caitlin_Knox Try doing it in Query Editor as given below.

format.png

Caitlin_Knox's avatar
Caitlin_Knox
Icon for Advocate III rankAdvocate III
11 years ago

Thanks for pointing me in the right direction.

 

The calculated columns aren't available in the query editor, so I simply duplicated the [Contract expiration date] column - marked it as a whole number, then called the copied column in my formula so as to result in a whole number.

 

Days Remaining in Contract = IF(AND(OMS[Contract expiration date]>TODAY(),OMS[expire year]<2048),OMS[Contract expiration date - Copy]-TODAY(),BLANK())

 

Thanks again!