Clay Icon

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?

  • Avatar of Channeled
    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!

  • Avatar of Dave B.
    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

  • Avatar of Muhammad S.
    Muhammad S.
    ยท
    ยท

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

  • Avatar of Dave B.
    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

  • Avatar of Dave B.
    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}]

  • Avatar of Daniel K.
    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!

  • Avatar of Dave B.
    Dave B.
    ยท
    ยท

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

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    You're welcome :)

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    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!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Dave B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: