Create a set of records by date in sequence?

Discussion created by tkalberg on Feb 3, 2016
Latest reply on Feb 5, 2016 by @ppear

Okay, I know this is probably a pretty simple problem but I'm a newb so thanks for your patience. I have a table that has one field in it, just the date. I use this table as a portal to display all the records in a related table by their date field. It's a production schedule that shows all the jobs for Monday thru Friday each week. Instead of manually creating a new record for each day and manually entering the date I would like to make a script that would automatically create a record for the next five days and skip the weekends. I'm sure this is possible but I haven't had much luck on my own. I hope that's enough info to go on and thanks in advance for the advice.