Mar 29, 2023 09:18 PM
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!
Solved! Go to Solution.
Mar 30, 2023 08:44 PM
IF({Media Consent},
IF(DATETIME_DIFF(TODAY(), {Consent Date}, 'days') < 365, 'valid, 'not valid')
)
This should do it.
Mar 30, 2023 12:16 AM
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.
Mar 30, 2023 08:44 PM
IF({Media Consent},
IF(DATETIME_DIFF(TODAY(), {Consent Date}, 'days') < 365, 'valid, 'not valid')
)
This should do it.
Mar 30, 2023 09:12 PM
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 🙂