7 Replies Latest reply on Dec 10, 2015 3:33 PM by user19752

    calculate the week ending on Friday

    rubinjm

      How do I calculate the week ending on Friday for the date in a record so I can do a summary report of weekly counts?

       

      I am using this calc for week beginning on Monday:

      Let ( dw = DayOfWeek(ED visit date) ; ED visit date - dw + 2 - 7 * (dw = 1 ) )

       

       

       

      But I need to compare to another dataset that uses week ending on Friday.

      Thanks–