Creating a Date Field Without Time: Simple Solutions

Dave B.

·Jan 02, 2025 05:51 AM·

I was trying to do something simple. Is there a way to have a date field without the time?

9 comments

· Sorted by Oldest

Channeled
APP
·
·
👋 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
Muhammad S.
·
·
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}]
Daniel K.
·
·
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.
Daniel K.
·
·
You're welcome :)
Channeled
APP
·
·
Hi Dave B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Channeled
APP
·
·
👋 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
Muhammad S.
·
·
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}]
Daniel K.
·
·
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.
Daniel K.
·
·
You're welcome :)
Channeled
APP
·
·
Hi Dave B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: