I have a table called "BOW" that has 2 columns: BOW and EOW (for beginning of the week and end of week).
I have a table called time that has records of hours employees worked including a field for "time in".
I want to create an expression that takes the "time in" date, searches between the BOW and EOW in the BOW table, and returns the BOW for the week that the "time-in" falls under.
Can anyone tell me how to do this or point me towards a resource that can?
Thanks.