+ Start a Discussion

Syntax Error



I am trying to create a new report to determine the Age of a Task from the created date... I tried using this formula


Today() - CreatedDate


However, it tells me " Error: Invalid custom summary formula definition: Field CreatedDate does not exist. Check spelling."


Why is this so? What should I do?









You need to create this new formula field  - return type number  on the object in setup,




 if you are using a custom report type, you need to add this field to the report type as well, and so after that this field would be available in your report, you only need to drag and drop.


in custom summary formulas you can only use numeric fields available in the report.


Mike KauravMike Kaurav



You have to do this with formula field, Create formula field , and choose return type as number in object. Then


formula is  "NOW()-CreatedDate"


add this field in to your report.




Kamatchi Devi SargunanathanKamatchi Devi Sargunanathan



Today() is meant for returning the datevalue alone, but created date will be a DateTime value.


So, you need to do is use the formula like this Today() - DATEVALUE(CreatedDate)


Hope so this helps you...!

Please give kudos by clicking on the star icon and mark this answer a Solution, if you found this answer as helpful.


Groundwire ConsultingGroundwire Consulting



Create new formula field  - return type number  on the standard or custom object,




For  more detailed information look at the fallowing link




and if you have any more questions please feel to contact me on support@groundwireconsulting.com