- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 11, 2023 10:09 PM
Golly, I do feel silly!!
