3 Replies · Latest reply on Nov 9, 2017 2:10 PM by Padmini Dommeti

    Add Time to date field

      Hi I have to add time to date field. Please help me on how to achieve this


      Example, I have below two fields:

      ( Date Type field ) EventDate : 09/11/2017

      (Time Field) EventTime : 13:00:00



      Now I have to calculated the StartDateTime and EndDateTime Values:


      StartDateTime = EventDate and Event Time which should be 09/11/2017 13:00:00


      EndDateTime = StartDateTime + 30 min i.e, it should be 09/11/2017 13:30:00


      Can any one through some light on what date functions can be used to achieve this