How can I automatically delete records from a table when today's date is say 30 days after the records' creation?

It seems you can only do automations based on numeric data types, so I just created a numeric formula that was 1 if the file is >30 days old and 0 otherwise, and then set the automation to run off that field as opposed to the date field.