Build calculations that use date fields

•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

  • Guest
  • Jul 13 2016
  • Reviewed: Voting Open
  • Attach files
  • Guest commented
    June 18, 2018 16:11

    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.

  • Guest commented
    March 29, 2018 13:58

    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.