August 12, 2018 at 7:25 pm
Hello All,
Basically my current selling session is Fall 1 2018 which has 36 selling days passed for school A and 33 for school. B. I'm trying to find the date of 36 days passed for previous session and prior year session for school A (33 day passed for school B).
school A 36 day passed for Summer 2 2018 is 6/8/2018 and Fall 1 2017 is 8/11/2017. How do I go about getting these dates?
School B 33 day pass for Summer 2 2018 is 6/8/2018 and Fall 1 2017 is 8/11/2017.
I set up a temp table with all the dates for Summer 2 2018 and Fall 1 2017 and use Row_Number function to assign a number for each date. Then update the ModifiedEndDate for Summer 2 and Fall 1 2017. This seems to be very cumbersome and wondering if there is a better way to accomplish this. The data do not line up well when i post, please see attached files. Your help/suggestion is greatly appreciated.
Thanks in advance
August 14, 2018 at 8:46 am
Duplicate post.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply