function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Dave The RaveDave The Rave 

Formula Field_Date/Time

I would like to create a new date/time field based on a foirmula:

RegistrationDate (for example) = 01/01/2019 13:45

(new field) Process Date = Registration Date + time = 11:59, so example:

Process Date = 01/01/2019 11:59

Thanks Dave
Sunil RathoreSunil Rathore
Hi Dave,

You can create a formula field. Please follow the following steps:
  1. Click on the New in the Custom Fields & Relationships section.
  2. Select Formula and click Next on the right-hand corner.
  3. Give Name and Label of the fields. Select Date/Time and click Next on the right-hand corner.
  4. Select Advanced Formula and then click Insert Field.User-added image
  5. Select field as per your requirement and click Next on the right-hand corner.
  6. Click Save.
Let me know if it helps you. If yes, then mark it as the best answer so it can also help others in the future.

Many Thanks,
Sunil Rathore
Dave The RaveDave The Rave
Hi Sunil, I am requesting the syntax here. So I have an existing data/time field:

RegistrationDate_c = example value 31/12/2019

I would like to create a new date/time field based on the date and time from RegistrationDate__c

New field is processdate__c formula need to be day of RegistrationDate__c + 1 and ther time needs to be 06:00, so and example value is 01/01/2020 06:00.

Thanks Dave
Dave The RaveDave The Rave
Sunil, I have reposted this question