Date formula with Timeline Block?

[Robert_Hudman]

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

[Robert_Hudman]

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

[Elias_Gomez_Sai]

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

[m66]

Did you find a solution for this?