Help

Formula to alert if more than 365 days from date

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
5457 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Kel_Asp
6 - Interface Innovator
6 - Interface Innovator

I have tried multiple way, know I am missing something, but can't work out what. 

I have one column for Date and the next column is yes. Meaning that consent has been given and on the date in the column. I now need a formula field that will return the word 'valid' if the consent date is less than 365 days from today, and 'not valid' if the consent date is more than 365 days from today. 

Hope I have explained that well. I have so many good ideas, and I truly do try to work them out before I come here 🙂 

Thanks in advance!

1 Solution

Accepted Solutions
IF({Media Consent},
   IF(DATETIME_DIFF(TODAY(), {Consent Date}, 'days') < 365, 'valid, 'not valid')
)

This should do it.

See Solution in Thread

3 Replies 3
Kel_Asp
6 - Interface Innovator
6 - Interface Innovator

I have kind of come up with a workaround that isn't exactly what I was after but works ok. 
I have used 

IF({Media Consent},DATETIME_DIFF(TODAY(), {Consent Date}, 'days'))

and then created a view filtered by that column, only showing if the column total is more than 365.  Hence giving me a view in which I can easily see if anyone's consent needs updating. 

 

IF({Media Consent},
   IF(DATETIME_DIFF(TODAY(), {Consent Date}, 'days') < 365, 'valid, 'not valid')
)

This should do it.

Thank you @Kenneth_Raghuna 
That works and gives me the valid, not valid row I was after. 

My work around was working too, but this is more what I am after. Thank you 🙂