Hey everyone! I’m working on an Airtable project and I’m stuck on something. I want to change how the date and time show up in my fields. Right now it looks like “Friday 29 November 2024 at 19h40” but I’d like it to be “Friday 29 November 2024 19h40” instead. I’ve been playing around with formulas but no luck so far. Does anyone know how to get rid of that pesky “at” in the middle? I’d really appreciate some help or tips on this! Maybe there’s a simple trick I’m missing? Thanks in advance for any advice you can give!
I’ve dealt with similar date formatting issues in Airtable before. From my experience, the key is using a custom formula field. Try this approach:
- Create a new formula field
- Use the DATETIME_FORMAT() function
- Your formula should look something like this:
DATETIME_FORMAT({YourDateTimeField}, ‘dddd DD MMMM YYYY HH'h'mm’)
This should give you the format you’re after without the ‘at’. The tricky part is escaping the ‘h’ with backslashes. It took me a while to figure that out!
Remember, you might need to adjust the formula slightly depending on your exact needs. Hope this helps solve your formatting puzzle!
hey ethant, i’ve run into this before. try using a formula field with DATETIME_FORMAT(). something like this should work:
DATETIME_FORMAT({YourDateField}, ‘dddd DD MMMM YYYY HH"h"mm’)
just swap {YourDateField} with your actual field name. hope this helps!
I’ve encountered this issue before in my Airtable projects. The solution lies in creating a custom formula field using the DATETIME_FORMAT() function. Here’s what worked for me:
DATETIME_FORMAT({YourDateTimeField}, ‘dddd DD MMMM YYYY HH"h"mm’)
This formula should give you the exact format you’re looking for without the ‘at’. The key is using double quotes around the ‘h’ instead of single quotes or backslashes. It’s a small detail, but it makes all the difference.
Remember to replace {YourDateTimeField} with the actual name of your date/time field. Also, you might need to tweak the formula if you want to change the order of elements or use different separators. Let me know if you need any further clarification!