I will try, please just keep in mind I may use the wrong vocab as I am self-taught and muddling through here.
I have two tables:
- Vehicle Assignments (shows the start and end date for when a specific vehicle was assigned to a specific driver and project. Vehicle, Driver, and Project all have their own tables related to Vehicle Assignments, just FYI))
- Driving Data (imported data from our telematics system that includes the Vehicle and Driver for driving events)
I am trying to get the driving data for a specific vehicle that occurred during the assignment period associated with that Vehicle Assignment record so that we can analyze the driving behavior for that assignment/driver/time period.
Record ID is the key field for the Vehicle Assignment table, and it is a legacy table that I am not trying to mess with. For that reason, I am trying to use a formula to identify the correct Vehicle Assignment record that corresponds with each Driving Data record, by matching up the Vehicle name between the two tables and then looking at the start/end date parameters from the Vehicle Assignment versus the driving event date.
Hopefully that makes sense!
------------------------------
Amy Christensen
------------------------------
