Testing calendar dates in database



  • I'm testing a registration system which involves a sender sending a daily update file to be processed to update the database systems. In this file there is a date field, and if populated, the date field for a particular record will change and the system will change the previous record's date to be the updated date - 1 calendar day. So if the updated file has a date of 31/3/14, the previous record will have a date of 30/3/14.

    So how would I be able to test this properly apart from the obvious? The only one I can think of is around the beginning/end of year, so for eg, if the update file contained a date of 1/1/14, then the system should update the date of the previous record to 31/12/13.

    Thanks



    • Leap Year (March 1st) - Roll back to Feb 29th
    • Non Leap Year (March 1st) - Roll back to Feb 28th
    • Test for month with 30/31 days
    • Check for Year End, New Year (Correct month and year applied)
    • Invalid Date Format Validations. Invalid patterns removed (MM/DD/YYYY, DD/MM/YY, DD/MM/YY HH:MM:SS)
    • Records with and Without zero are handled properly, 01/01/2014 is handled same as 1/1/2014

Log in to reply
 

Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2