Test Data For Date Fields

• 0/0/0000

• (yesterday)

• (today)

• (today with all leading zeros, like 01/01/2006) 

• (tomorrow)

• (same day last week)

• (same day next week)

• (same day last month)

• (same day next month)

• (same day last year)

• (same day next year)

• (Jan 1 this year)

• (Dec 31 this year) 

• (Jan 1 last year)

• (Dec 31 last year) 

• (Jan 1 next year)

• (Dec 31 next year) 

• 1/1/1999

• 12/31/1999

• 1/1/2000

• 2/28/2000

• 2/29/2000

• 2/30/2000

• 2/31/2000 

• 3/1/2000

• 12/31/2000

• 1/1/2001

• 1/1/202 

• 2/28/2004

• 2/29/2004

• 3/1/2004

• 12/31/2004

• 9/9/9999

• 2/29/2001 

• 4/31/2001

• 9/31/2001 

• 2/29/2100

• 13/1/2006

• 00/1/2006

• 01/32/2006

• 01/00/2006

•  June 5, 2001
  

• 06/05/2001

• 6/5/2001

• 06/05/01

• 6/5/01

• 06-05-01

• 06-05-2001

• 6-5-01

• 6-5-2001