null date insertion
I have a simple running journal. Each entry has a date and a distance ran. I’ve kept this record for about 6 months.
Recently I discovered I have to add missing dates with “0 miles ran” in order to get correct results with a moving average calculation.
I’m looking for suggestions for searching un-noted dates, creating a record, and entering 0 miles. I’m a little overwelmed with how to handle this task via a script.
Only way to do that that comes to mind is to create a script that sorts your records by date and then loops through them comparing the date in the current record to the date in the previous record to find cases where the dates "skip" one or more dates.