Creating a Date Field Without Time: Simple Solutions

This is Engagement Start Date. Here's how it looks, and I couldn't find a way to change the Date format like Airtable

You can add a new formula column and have it return only the date from this columb

I see an issue there. You then need to change the field to 'TEXT', and my other formula field breaks if I write a formula on the TEXT field reference

What I'm looking for is Engagement Start: [date] Next Invoice: [calculate date] Due On: [calculate date as 7 days from {Next Invoice}]

Hi Dave! Happy to help! 😊 You can use the Format/Date Time integration to show a date without it's time. https://downloads.intercomcdn.com/i/o/w28k1kwz/1318699719/50697c7159c19daa13d2da46f8ac/Berrycast_sJ4ktiuUns.png?expires=1735825500&signature=45b6abca1f9e9773068b70737bc2f1e95ec1490edf1b05bdc9cfa34bab899fa9&req=dSMmHs93lIZeUPMW1HO4zUiNBvftWVh9FDoKAUzSHmVZuAqPH%2F%2FYSJRV4Lr6%0AnZ%2FK%0A Generally, if you want to run calculations, it's recommended to use the AI Formula Generator (returns javascript code to perform the calculation). Feel free to reach out if you need further assistance!

Thank you Daniel. This is awesome. I didn’t dig enough it seems. Thanks again.

You're welcome :)