Activity post timeout

Hello all, I am building out an app for an ocean fleet.

I have been trying for a bit to create some functionality but I cannot quite figure it out.

The captain’s will post weather updates to an activity feed. They have requested that the post disappears after 24 hours from the time it was posted. I’ve made the posts have a date/time stamp go into the database. I was looking in the visibility settings and set it to “sometimes visible” but I cannot figure out the database settings to select in order to hide a post after 24 hours.

Any help would be appreciated. Thanks!