This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I currently have a table of all the business days of the year. WorkingDays [BusDate]. I have a file that contains the current date WorkingFile [CurrentDate]. I am trying to figure out how to find the previous business day from the [BusDate] field in the WorkingDays table using the [CurrentDate] in the WorkingFile table, and return it to a field labeled [PriorBusDate] in the WorkingFile. For some reason this is difficult for me.