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
Tracy Oden 31Tracy Oden 31 

Can someone help me with writing an IF statement that includes an ISBlank check on a date field that returns a datetime?

Hi, I am trying to write a datetime formula but having a problem. The goal is to check a 'date' field (Service_Date__c) to determine if the (Service_Date__c) date field is blank. If the (Service_Date__c) date field is blank, I want to return null. If the date field is not blank, then I want to return the following 'datetime' formula DateTime__c +   300/1440.

I have some other formulas dependendent on the 'datetime' formula DateTime__c. The DateTime__c field is a formula field that is depenendent on the Service_Date__c 'date' field--all of which are throwing errors. I can fix the errors if I can get help with the above.

Thank you in advance!

IF(NOT(ISBLANK(Service_Date__c)), DateTime__c   +   300/1440)
Best Answer chosen by Tracy Oden 31
Dev BoorlaDev Boorla
Hi,
You will need to provide 3 params lik below:
IF(NOT(ISBLANK(Service_Date__c)), DateTime__c   +   300/1440, null)


Best,

All Answers

Dev BoorlaDev Boorla
Hi,
You will need to provide 3 params lik below:
IF(NOT(ISBLANK(Service_Date__c)), DateTime__c   +   300/1440, null)


Best,
This was selected as the best answer
Tracy Oden 31Tracy Oden 31
That worked!  Thanks so much. 
Julie Hopkins 8Julie Hopkins 8
That helps a lot. Thank you!
celeb networth (https://www.celeb-networth.com/)