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