Skip to main content
Topics#Data ManagementPregunta de Mary Clevidence
Mary Clevidence (TCS John Huxley) preguntó en #Data Management
30 jun 2016, 16:17

Converting Date to a Date / Time Field

I have employees entering in the beginning and ending dates of a request in date fields.  I need to then convert those dates into a Date/ Time Field with the beginning date having the time of 12 am, and the ending date having a time of 5pm.   I need this so that I can create an event in process builder

 

I tried DATETIMEVALUE (Begining_date_c) but it returned today's date
3 respuestas
  1. Kiran Ravikanti (Biogen)
    30 jun 2016, 16:30
    Try:

     

     

    DATETIMEVALUE(TEXT( Date_Field__c) + TEXT( Number_Field__c) + ':00:00')

     

     
Escribir una respuesta...
0/9000