I have a data set with actual dates tied to each line and wish to populate a Fiscal Year/Period/Week for the respective date. I have a separate file with the Fiscal calendar all the way back to 2015. Is there a simple way to join the two so that if it reads the arrival date on file one, it populates the respective Fiscal information from file two?
Hopefully one of those will get you what you need.
Regards, Brett
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
