Discussions

 View Only
Expand all | Collapse all

Help With Function That Returns Today Date

  • 1.  Help With Function That Returns Today Date

    Posted 12-19-2017 18:11
    I am trying to write and if statement that checks a follow up date field to see if it is greater than or equal to today date. I can't seem to get rid of the syntax error. Here is my current formula.
    =IF(Today()>=[Next_Follow_Up_Date],"Action Needed","No Action Needed"))

    Any help is greatly appreciated.


  • 2.  RE: Help With Function That Returns Today Date

    Posted 12-19-2017 18:16
    there is an extra ) at the end of formula.