Forum Discussion

Alison Keith Elliott's avatar
Alison Keith Elliott
Copper Contributor
Jul 20, 2018
Solved

drop the time from a date time field

I need to drop the time from an imported field that is date time.  For example, the field imported as 1/26/2018  8:14:00 AM I need it to be only the date of 1/26/18 Is there a quick and easy formu...
excel
Formulas and Functions
  • Matt Mickle's avatar
    Matt Mickle
    Jul 20, 2018

    If your dates are in column A.  Just use this formula in a helper column then copy and paste values and delete the original column.

     

    =TEXT(A2,"M/D/YYYY")

Matt Mickle's avatar
Matt Mickle
Bronze Contributor
Jul 20, 2018

If your dates are in column A.  Just use this formula in a helper column then copy and paste values and delete the original column.

 

=TEXT(A2,"M/D/YYYY")

Resources