You need to sign in to do that
Don't have an account?
Loran 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
DATETIMEVALUE(Customfield__c) + (9.5/24)
Regards,
Chris
All Answers
DATETIMEVALUE(Customfield__c) + (9.5/24)
Regards,
Chris