Sep 09, 2021 02:08 AM
Hello, can I use date DD-MMM-YY date format like I can with Jotform? Some services will only use the American date format, so I like to use MMM for the month letters, otherwise it’s very easy to mix up the day and month. Tomorrow for example is 10/9/21 - that’s 10th September, unless you’re American then it’s 9th October… sorry, I mean October 9th.
I know I can use “friendly format” which shows the full length of the day and month (i.e “Friday, 10th September, 2021”) and cuts off half the date unless the column is unnecessarily wide.
I’ve looked at this thread but it doesn’t mean much to me:
Solved! Go to Solution.
Sep 09, 2021 04:16 AM
Welcome to the Airtable community!
When displaying a date field in Airtable, you can only pick from the few formats listed in the field customization box. You can use a formula field to show almost any format, but the result will be in the formula field and would not affect the original date field. When I want a less ambiguous way of showing dates, I often resort to ISO format (YYYY-MM-DD)
Sep 09, 2021 04:16 AM
Welcome to the Airtable community!
When displaying a date field in Airtable, you can only pick from the few formats listed in the field customization box. You can use a formula field to show almost any format, but the result will be in the formula field and would not affect the original date field. When I want a less ambiguous way of showing dates, I often resort to ISO format (YYYY-MM-DD)
Sep 09, 2021 04:33 AM
Thank you kuovonne. It’s not ideal, but I guess it’s the best solution.