8 Replies Latest reply: Dec 14, 2017 12:21 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!!!