I have a data set with two different dates, one is created on and the other closed on, while creating a weekly report I need the data for the table to match the week the report is pulling for, how would I assure that the created on and closed on dates are for the same time frame? Thank you.
Maybe you can try like this, create an additional field with week_common and logic like that, if (week(created_on)=Week(closed_on), Week (Created_on), Different_week).
Trial and error is the key to get unexpected results.
