AnsweredAssumed Answered

calculate the week ending on Friday

Question asked by rubinjm on Dec 7, 2015
Latest reply on Dec 10, 2015 by user19752

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–

Outcomes