Skip to main content

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 Antworten
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    30. Mai 2024, 11:56

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

    BLANKVALUE(CompletedDate, TODAY())-DATEVALUE(CreatedDate)