Help

Date formula with Timeline Block?

8045 22
cancel
Showing results for 
Search instead for 
Did you mean: 
Robert_Hudman
6 - Interface Innovator
6 - Interface Innovator

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 work?
Very important for me and hoping there is a solution.

Thanks, Rob

22 Replies 22
Robert_Hudman
6 - Interface Innovator
6 - Interface Innovator

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 it would be worth mentioning.

Thanks, Rob

Yes, DATETIME_PARSE is like the opposite of DATETIME_FORMAT, they’re just next to each other in the docs: https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-reference#date_and_time_funct...

I think the general tip here was to remove the DATETIME_FORMAT, do you really need it? You can format the Formula result with several options: https://support.airtable.com/hc/en-us/articles/203229705-Guide-to-the-basic-field-types#date

fdec5da34d14399ccdad7527eb490da66123e852.png

5de959090bb76af0795442f6da62d9b4460f8a66.png

Did you find a solution for this?