Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  ASP.NET  want some validations for the date fields used....

Author  Topic  sheena Starting Member 45 Posts Posted - 2007-04-06 : 01:48:33 Hello Members, I m using two fields of the date that is the manufacturing date and the expiry date of some items.It is also having the order date to placed which record the system date. I want the some condition that the order date should not be greater than today's date. And also want to know is there any validations or restrictions to put on for the mfg date and exp date.Like mfg date <> exp date. I m working in asp.net 2005 with C# coding. I have created my database in sql server 2005. I have used javascript datepicker for the date fields which when selected gets displayed on the textbox. The dateformat which is used is as follows :: d-MMM-yyyy 15-Apr-2007 Waiting for ur some suggestions and help to solve my problem. Thanxs in advance.