•Current Function: Currently, calculated fields can calculate using decimal and currency fields with basic formulae
•Desired Function: Recently a client asked that we allow calculated fields to include dates, much like Excel is able to.
•Reason for Function: The reason for this is to quickly determine the number of days between grant receipt and review, review and approval, then approval and payment. This will help ease the burden of manual calculation and increase efficiency of reporting
As a corollary to this, also allow 'calculation' with Boolean fields. Our Stage 1 applications use Yes/No answers for a series of questions and we would like to sort a list of applicants by the number of 'Yes' answers.
I was about to enter this Idea. It may have been me who is the client mentioned.I would be interested to know what the review result was. This would help (but not solve) the task we face of manually entering many due dates for varying periods for all the different progress reports our organization requires.