Extract Date from Date and Time in Date Column

I have data pulled into a date column in this format: 6/1/2022 7:30:57 AM This is not a system-generated field.

I need the date only in another date column.

Thanks for any help!

Lori Flanigan


Best Answer

  • Toufong Vang
    Toufong Vang ✭✭✭✭✭
    Answer ✓

    =LEFT(Timestamp@row, FIND(" ", Timestamp@row))

    In your timestamp, the date is immediately followed by a space (" "). Find the position of that space and then take the leftmost characters of that position.

    For example, in "6/1/2022 7:30:57 AM" the space is the 9th position. Grabbing the 9 leftmost characters returns "6/1/2022 ". Smartsheet automatically trims spaces so you're left with "6/1/2022".

    LEFT( Timestamp@row, position_of_space ) returns the date.

    FIND(" ", Timestamp@row) returns the position of the space character.

    Put together, your formula is =LEFT(Timestamp@row, FIND(" ", Timestamp@row)).


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!