Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 11, 2023 02:01 PM
Quick one, I use date_add to calcuate a bunch of dates in different field. Now, I'm realising that even tho I use "Datetime_Format" airtable can't easily interpret those as dates if I want to sort by them or make timelines etc.
Here is an example of a date formula I use.
Now, as I need to sort by these for various views, use them in timelines, etc, I end up making a new field called "[date field] PARSED" which is just using the "Datetime_parse({CALCULATED DATEFIELD})." Is there a way to simplify this so I don't need 2 fields displaying the same date? I tried replacing the "datetime_format" wrapping on these with "Datetime_Parse" to no avail. I sort of understand that on the "IF" statement formulas, that it may not work, but I would've thought the latter formula could easily handle the datetime_parse formula.
I am trying to clean up bases as there are a LOT of fields in some of these that make it hard for new users, and even myself when it comes to tinkering the design.
Solved! Go to Solution.
Aug 11, 2023 05:45 PM
If you only want to output dates, you do not need Datetime_format.
Formula and rollup fields can be formatted if the output is a date type.
Datetime_format is a function that returns a string type and is used to insert a date into a string.
Aug 11, 2023 05:45 PM
If you only want to output dates, you do not need Datetime_format.
Formula and rollup fields can be formatted if the output is a date type.
Datetime_format is a function that returns a string type and is used to insert a date into a string.
Aug 11, 2023 10:09 PM
Golly, I do feel silly!!