Automatically linking to records from the day before?

I have a table for tracking sleep as well as a second table to track how long I was awake each day. I’ve been filling out the “Awake” table manually so far, but I’m trying to have it automatically populate. So far I have the table successfully linked to the date, day, week, and wake time, but I’m having trouble filling the bedtime. I need to link to the bedtime from the record from the day before the current record is linked to. The previous record would also work. I’m not sure how to do this. I’m very new to automations in general and trying to practice. Help? There’s probably something obvious I’m not thinking of