4 Replies Latest reply: Sep 18, 2017 3:36 PM by Wes Browning RSS

    How to use Today()

    Wes Browning

      Hi everyone... 

       

      I'm trying to understand how I can use the Today() function to specify day, month, year (or whatever else is available) in functions such as the one below:

       

      =(Count({<[Date/Time Opened.autoCalendar.Year] = {'2017'}>} [Case Number]))

       

      Instead of manually entering '2017' I want to leverage Today() (or other) to tag the current year dynamically.  Can also see uses for this in referencing # weeks or months into current year, month, day, etc...  Please let me know if this is enough info and I can add more as needed.

       

      Thanks in advance for the great help I always receive here!!!