5 Replies Latest reply on Dec 13, 2013 11:10 AM by Katherine Woods

    Need advice on: Error ORA-01830:Date format ends before converting entire input string

    Katherine Woods


      New Tableau user here. I am using the following datetime field round up code:

       

      datetime(round(float([My Datetime Field])*(1440/30),0)/(1440/30))

       

      To round a date time field formatted as mm/dd/yyyy hh:mm:ss AM/PM. I am trying to round up the minutes to the nearest 30 minute interval but am getting the above error. Do I need to truncate the seconds and AM/PM here? I don't have a problem truncating off the seconds but I really need to keep the AM/PM portion to make the data meaningful.

       

      Thanks for any help!