1 Reply Latest reply on Nov 19, 2012 9:17 AM by philmodjunk

    null date insertion



      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.

        • 1. Re: null date insertion

               Sounds like you want to find a record that doesn't exist. wink

               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.