Our Training Programs

All contents are copyright of their authors.

date checking validation and time validation

date checking validation and time validation

siva balan

10yAsked Oct 11, 2016, 1:44 AM857

Hello guys i have one doubt

My selected date is current date to next 7 days only allowed other date means don't allowed in sql (or) c#

ex:my selected Date(11-10-2016) Allowing Dates are (11-10-2016,12-10-2016,13-10-2106,14-10-2016,15-10-2016,16-10-2016,17-10-2016)

My another one doubt is My selected time only allowed Morning(10:00 to 23:00)

please help me

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Manas Mohapatra10y ago
Try like this :
DateTime selectedDate = DateTime.Now.AddDays(6);
DateTime validDate = DateTime.Now;
TimeSpan startTime = new TimeSpan(10, 0, 0);
TimeSpan endTime = new TimeSpan(23, 0, 0);

if (validDate.AddDays(7) >= selectedDate &&  selectedDate >= validDate
    && ((selectedDate.TimeOfDay > startTime) && (selectedDate.TimeOfDay < endTime)))
{
    Console.WriteLine("Valid Date");
}
else
{
    Console.WriteLine("Invalid Valid Date");
}
siva balan10y ago
selected value only store in database . Before storing i want to validate this ...
Manas Mohapatra10y ago
You are selecting the date in UI, right? If yes, it is better to put in javascript.
Please describe when I select a date, what value you want to store in SQL..