Skip to main content
Topics#Data ManagementNick Mirams's Question
Nick Mirams asked in #Data Management
Sep 23, 2015, 12:29 PM

if field is blank calculate using NOW() else do this calculation

Hi,

 

I am trying to wrote a formula which calculates between two date/time fields.....a closed date and another date.

 

First it needs to check if the closed date is blank and if it is, the calculation is NOW() - another date else the calculation is closed date - other date.

 

I tried this and got a character limit error.

 

IF(ISBLANK(ClosedDate),NOW() - ENT_2__Actual_First_Response__c ,

 

ClosedDate - ENT_2__Actual_First_Response__c)
4 answers
  1. Sunil Sarilla (M&G Investments)
    Sep 23, 2015, 12:36 PM
    Hi Nick,

     

    Please try the below and see if you are still getting the character limit error

    BLANKVALUE(ClosedDate,NOW()) - ENT_2__Actual_First_Response__c

     

     
Write an answer...
0/9000