Articles in this section
Category / Section

How to set data validation for Date?

1 min read

Use the following code snippets to set data validation for date.

C#

//Data Validation for Date
IDataValidation validation = sheet.Range["A5"].DataValidation;
sheet.Range("A5").Text = "Enter the Date";
validation2.AllowType = ExcelDataType.Date;
validation2.CompareOperator = ExcelDataValidationComparisonOperator.Between;
validation2.FirstDateTime = New DateTime(2003, 5, 10);
validation2.SecondDateTime = New DateTime(2004, 5, 10);
validation2.ShowErrorBox = True;
validation2.ErrorBoxText = "Enter Value between 10/5/2003 to 10/5/2004";
validation2.ErrorBoxTitle = "ERROR";
validation2.PromptBoxText = "Data Validation using Condition for Date";
validation2.ShowPromptBox = True;

VB

        'Data Validation for Date
        Dim validation2 As IDataValidation = sheet.Range("A5").DataValidation
        sheet.Range("A5").Text = "Enter the Date"
        validation2.AllowType = ExcelDataType.Date
        validation2.CompareOperator = ExcelDataValidationComparisonOperator.Between
        validation2.FirstDateTime = New DateTime(2003, 5, 10)
        validation2.SecondDateTime = New DateTime(2004, 5, 10)
        validation2.ShowErrorBox = True
        validation2.ErrorBoxText = "Enter Value between 10/5/2003 to 10/5/2004"
        validation2.ErrorBoxTitle = "ERROR"
        validation2.PromptBoxText = "Data Validation using Condition for Date"
        validation2.ShowPromptBox = True

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied