How do we test the date field with edit box and Submit button which connects to SQL? What is the approach we should test this?

Showing Answers 1 - 3 of 3 Answers

*    first check the formate for Date field like DD/MM/YYYY,MM/DD/YYYY

*    next check for what should be the seperator '/' or '-'

*    month values should be between 1-12.(so check for <1 and >13)

*    then for date field ensure date should be between 1-31 for jan, march,may,july,aug,oct,dec.(so check for <1 and >31)

*    then for date field ensure date should be between 1-30 for april,june,sep,nov(so check for <1 and >30)

*    also ensure date should be between 1-28 for feb month and 1-29 for feb month during  leap year.

*   ensure that you entered year value in 4 digits(ex: 2008) but not 2 digits.

*   also check by entering blank spaces into all fields.

*   also by entering 0's in all fields.

*   check for decimal/fractions also

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions