Skip to main content
Topics#Data ManagementDomanda di Mary Clevidence
Mary Clevidence (TCS John Huxley) ha fatto una domanda in #Data Management
30 giu 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 risposte
  1. Kiran Ravikanti (Biogen)
    30 giu 2016, 16:30
    Try:

     

     

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

     

     
Scrivi una risposta...
0/9000