Hi There
I am trying to set up a formula to read from a single date field and provide an output text to give me three desired output. As below:
If the date <= today’s date + 30 days - show as “30 days”If the date <= today’s date + 60 days (but not eq...
Hi All
I am in early stages of learning formula functions, and focusing on date based formulas.
One thing I have noticed is that dates created from formula calculations to not seem to work with the Timeline block.
Has anyone found a way to make this ...
Hi Guys
Just found out that you (should be able to) convert the date string from using the DATETIME_FORMAT formula into a proper date format that the Timeblock can read by wrapping it in a DATETIME_PARSE formula.
Have not tested it out, but thought i...
Alright…just figured out there is a DATEADD function! :grinning:
Using this it seems to work:
IF({Conservative Date} <= DATEADD(TODAY(), 30, ‘days’),“30 days”,“nested”)
Can anyone give me advise on how to deal with the 60 days and 90 days in the ...
Hi Elias
I don’t know if I have somehow not followed your instructions(?), but can assure you I worked through them in detail before coming back to ask follow up questions.
Your advice is great appreciated.
Robert
