You need to sign in to do that
Don't have an account?
Dave 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.
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.