SOLVED

Date to Text Calclution

Copper Contributor

Any help on a date to text calculation 

I Have have a single Line of Text field and would like to calculate the following

 

 

 

=IF([Next Review]-30<TODAY(),"1 Month","Published",IF([Next Review]-60<TODAY(),"2 Month","Published",IF([Next Review]-90<TODAY(),"3 Month","Published")))

 

 

 

 

 

For some reason It is not displaying.  Am I missing something

2 Replies
What I am trying to achieve is - If The Next Review date is within the next

30 days from today it should say 1 month,
Next 60 Days from today 2months,
Next 90 Days from today 3 months
best response confirmed by Sn3l3 (Copper Contributor)
Solution
Got it fixed.
Needed to remove the, "published" from all and only leave at the end.
Thank you however.
1 best response

Accepted Solutions
best response confirmed by Sn3l3 (Copper Contributor)
Solution
Got it fixed.
Needed to remove the, "published" from all and only leave at the end.
Thank you however.

View solution in original post