Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question
  • 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
share|improve this answer
Good answer. A few of these might help, too:… – Joe Strazzere May 20 '14 at 16:09

In addition to Siva's answer, I would add that there are many valid date/time formats that are different from each other. What all date formats are allowed?

This can also be applied to the time format if you have timestamps. Is 24 hour time supported, etc.?

What about timezones? If an update is pushed from a server in India and processed on a server in the US, does anything special happen (shift time to US time and then -1 day). Maybe this doesn't apply to your system.

share|improve this answer
+1 for timezones. – dzieciou May 21 '14 at 3:38

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.