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 

Change Date/Time field to specific time & existing date

All, having difficulty solving this issue,

I would like to create a formula for a Day/Time field called ProcessDate__c. I would like to take the date from the date/time field registrationdate__c and just amend the time.

Using a formula recommended through the forum, but still can solve issue as this formula adds one day.

DATETIMEVALUE( TEXT( DATEVALUE( RegistrationDate_c ) ) +" "+ "23:59:00" ) - 0.041

if registrationdate__c = 01/01/2019 10:00 then processdate__c should be:
01/12/2019 23:59 not 02/12/2019 23:59

Thanks Dave

oh, 0.041 is for the GMT+1 timezone.