Skip to main content
Sagar Singhal (Barclays) ha fatto una domanda in #Formulas

I want to create a row level formula on a report where I need to calculate age between two fields One Completed date - created date ...but if the completed date is blank it needs to be calculated as Today- Created date is it possible..?? and if yes .. please write the formula; 

10 risposte
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    30 mag 2024, 11:56

    I got the dates mixed up, try this (or Helene's answer, same result):

    BLANKVALUE(CompletedDate, TODAY())-DATEVALUE(CreatedDate)
0/9000