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 answers
Eric Praud (Activ8 Solar Energies) Forum Ambassador
I got the dates mixed up, try this (or Helene's answer, same result):
BLANKVALUE(CompletedDate, TODAY())-DATEVALUE(CreatedDate)