function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Loran SeutersLoran Seuters 

DATETIMEVALUE reminder at fixed time, relative date

Hi all, 

I have a question regarding the DATETIMEVALUE function. I'm creating a task each time a projects starts, and i would like to set the reminder at 09:30:00. So the date is based on a field, but the time should be fixed. I have tried multiple formulas, currently i have the following: 


DATETIMEVALUE(Customfield__c  & " " & 09:30:00) 

However, i receive an error that i miss a bracket: 

The formula expression is invalid: Syntax error. Missing ')'

Anyone any ideas? 

Kind regards, Loran

 

Best Answer chosen by Loran Seuters
ChrisludoviceChrisludovice
Please try

DATETIMEVALUE(Customfield__c) + (9.5/24)

Regards,
Chris

All Answers

ChrisludoviceChrisludovice
Please try

DATETIMEVALUE(Customfield__c) + (9.5/24)

Regards,
Chris
This was selected as the best answer
Dave The RaveDave The Rave
Hi Chris, I am have the same issue. However, the formula above only adds 9.5 hours to the time in the customer field.  I have looking to create a formula for a date field so the date is not change, but the time is changed to a fixed time. That is 23:59, can a DATETIMEVALUE formula be used?