Since the option to record a date in a work flow can not be added in before copying rows action there is a work around. First record a date when a date is reached, set to the conditions within the periodic. Finish by record a date, do not assign in this work flow or copy to a data base that is automated to distribute the periodic work.
Secondly build a workflow in same periodic sheet that is when rows are changed trigger and when a date changes to any set alerts here or as I did copy to the sheet that holds the trigger automation to disseminate out.