.png&w=3840&q=75){kind=logo}
Creating a Date Field Without Time: Simple Solutions
I was trying to do something simple. Is there a way to have a date field without the time?
👋 Hey there! Our support team has got your message - we'll be back in touch soon. If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Dave B.··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
- Dave B.··
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
- Dave B.··
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!
- Dave B.··
Thank you Daniel. This is awesome. I didn’t dig enough it seems. Thanks again.
You're welcome :)
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!