I’m getting error DateOfBirth_46 showing up for a learner on a new standard with a start date of 10th May 2017 and an end date of 16th May 2018.
I can see why they would return this error – computers are as bad with dates as people are (is tomorrow one day away because it’s not yet tomorrow, or no days away because there aren’t any in between?) – but it’s incorrect by two of my reckonings.
I used Excel firstly, where each date is represented by a number, meaning the start date plus the remaining number of days gives the final date:
Secondly, as a check I have counted the weeks and days on the calendar:
There are 53 full weeks including the start date and the day outlined in grey, the 15th of May 2018, plus the end date; this gives 372 as I’ve shown in the calculation underneath.
These standards have been going for a little while now, so I’m wondering why this apparently hasn’t been sorted already. I will probably have to adjust the end date, at least for the upload, but I prefer to solve problems than work around them.
There are various functions that can be used to determine how many specified time intervals exist between two dates and these return 371 days for the dates you have entered.
Its a bit like counting the gaps between the posts.
Just add a day.
I’ve had a look into this and rule isn’t behaving as intended. For some reason it was not looking at the first and last days whilst making the calculation. I’ve raised the defect and am reducing the error to a warning in the mean time.