Skip to main content
Topics#Customer ServicePregunta de Nyota Peek
Nyota Peek (AVOXI) preguntó en #Customer Service
26 ene 2017, 12:18

How can I create a formula for "Days Since" between 3 dates?

I would like to build a formula - if possible - that shows number of days since account date creation from "Today or NOW" but only use custom field of account date creation if cancellation date is null. If cancellation date is not NULL then to use cancellation date vs account date.

 

Ex. If cancellation_date__c is NULL then Today () - account_date__c, but if cancellation_date__c is not NULL then Today () - cancellation_date__c

 

Can someone help with the true syntax for this formula logic? Is this possible? Was trying to prevent creating 2 different fields -- 1 for tracking days account created and then 1 for days account til cancellation. 

 

Thanks!
8 respuestas
  1. Sunil Sarilla (M&G Investments)
    26 ene 2017, 12:52
    Hi Nyota,

     

    Ok your latest explanation makes it clear, so you need to count the number of days between Account creation date and cancellation date, if the cancellation date is blank use Todays date.

     

    Please try the below

    DATEVALUE(account_date__c) - BLANKVALUE(DATEVALUE(cancellation_date__c) , TODAY())
Escribir una respuesta...
0/9000