You need to sign in to do that
Don't have an account?
Charni Wiggins
DateTime formula field returning null - add time to date
I am trying to create a formula that adds a specified time to a date. It keeps returning empty at the moment for some reason. I need it for a process which will send an email at this datetime. This is what I have tried so far.
Follow Up Time: Time
Consent Email Sent: DateTime
Follow Up Time: Number
Consent Email Sent: DateTime
Much appreciate any help!
Follow Up Time: Time
Consent Email Sent: DateTime
DATETIMEVALUE(TEXT( Consent_Email_Sent_INTERNAL_USE_ONLY__c ) + TEXT(Follow_Up_Time__c))
DATETIMEVALUE(TEXT(Consent_Email_Sent_INTERNAL_USE_ONLY__c)&" "&TEXT(Follow_Up_Time__c))
Follow Up Time: Number
Consent Email Sent: DateTime
DATETIMEVALUE(TEXT(Consent_Email_Sent_INTERNAL_USE_ONLY__c) + TEXT(Follow_Up_Time__c) + ':00:00')
Much appreciate any help!
Assuming that Follow_Up_Time__c is a Number field showing the number of hours See this documentation (https://help.salesforce.com/articleView?id=000221466&type=1).
All Answers
Assuming that Follow_Up_Time__c is a Number field showing the number of hours See this documentation (https://help.salesforce.com/articleView?id=000221466&type=1).
Thank you for your reply. It seems to be returning 01:00 for the time but should be 08:00. The number field is a formula number field with 8, is that ok?
Yes, assuming that your intention is to add 8 hours to the Consent_Email_Sent_INTERNAL_USE_ONLY__c date time
Thank you,
Charni
No worries, thank you for your help! :)