2 Replies Latest reply: Oct 19, 2017 7:30 PM by Alec Smith RSS

    Remove Timestamp

    Alec Smith



      I am trying to remove the timestamp on a date field.  The date values are formatted as 2017-02-23T00:00:00.


      I tried the following functions to remove the timestamp but, they all did not work.


      • Date(Floor(Date),'YYYY-MM-DD) As Date
      • Date(Date#(Left(Date,10),'YYYY-MM-DDT00:00:00'),'YYYY-MM-DD') As Date
      • Date(SubField(Date,' ',1)) As Date

      Does anyone have suggestions as to how I can remove the timestamp? 


      Thank you in advance for any assistance!