- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 13, 2025 07:07 AM - edited Feb 13, 2025 07:11 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 13, 2025 07:19 AM - edited Feb 13, 2025 07:20 AM
Without knowing what causes this:
Wouldn't wrapping your Start Date formula inside a DATETIME_FORMAT, and uniformizing the formats that way, solve this?
Best, Milan - Automable.AI Free Airtable consultation
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 24, 2025 12:20 AM
@Milan_Automable I found the cause and solution to my problem. Here it is for possible future readers.
Even though lookups of date fields may look like date fields – 1. they have date formatting in their setting, 2. DATETIME_FORMAT can be applied to them, 3. sorting can be applied to those fields in views –, their values remain essentially arrays. One-item arrays of a date to be precise.
So to convert those arrays to date values, the trick is to use a combination of ARRAYJOIN and DATETIME_PARSE. This time, the sorting by date in the Automations panel will work.
