Validator To Compare Two Date Difference Is Not More Than 12 Months?
Feb 22, 2010
I have two TextBox controls for start date & end date input. I have to validate that end date is not greater than start date & the difference between start date & end date is not more than 12 months.
I have a date textbox. It has three validators on it. One is RequiredFieldValidator, second is CompareValidator and the third is RegularExpressionValidator.
CompareValidator checks for LessThanEqual for current date. For example if user enters date greater then todays' then it should display error message. It does that.
Problems is if user enters invalidate e.g., 2009/05/0d then I see two error messages. One for invalid date and one for compare. In this specfic case I want to see only one error that 'Date is invalid'. But some how I see two mesages.
Now what i need is i will have a pop up calendar after the text box when i click on edit . If i select a date greater than the date existed in the text box i would like to set my Database field to Yes..
When attempting to place controls in different content areas using Masterpages and trying to use a compare validator, I get the error: Unable to find control id 'txtStartDate' referenced by the 'ControlToCompare' property of 'cvlDate'. I have also attempted to set it within the c# code behind in page load: cvlDate.ControlToCompare = txtStartDate.ID and by using findControl there must be an easy way to achieve this?
When it comes to field validation, when I use a Compare Validator to make sure a date is a date or a numeric field has a number, I must also use a Required Field Validator to make sure there is something actually enetered. In other words, the Compare Validator allows a blank value even though a blank is not a date or number or whatever.
Is using both a Required Field Validator and a Compare Validator the way to do this or is there some way to make the Compare Validator also require input of some kind?
I need to find a date 6, months from the current date. How to do it. I use dd/mm/yyyy format. I could use add 6 to mm part, what if it goes beyond 12 ? but it could still be done, I know. I want to know if there is any easy way to do it.
I am trying to check for a condition such that a date in an input control (textbox) is not greater from a date 1 years from current date(exactly) and also it should not be less than a date 1 year back from current date. for eg. if today's date is "21/dec/1990" then usen cannot enter a date in textbox which is less than 21/dec/89 and it should not be greater than 21/dec/1991. for this i first tried to confirm the greater than condition, i wrote the following code:
I have an "effectivedate" field that is displayed using a label inside a detailsview control... In the code behind I need to add 12 months to this to check if a policy is up for renewal or not...
To find the control I use this code... Dim EffectiveDate As Label = DetailsView1.FindControl("EffectiveDatelbl").ToString But when I try and convert the label to datetime type using this... Dim ExpireDate As DateTime = EffectiveDate.AddMonths(12)
I get the error - Cannot convert string to date, addmonths is not a member of label etc...
How to get the date at which a record is created in SQL?..i.e, if i add a record to a database table db1 at 8/10/2010 11:30, I want to get the datetime, i.e 8/10/2010 11:30..;.Also let me know how to compare datetime values..
if(8/10/2010 11:30 >8/10/2010 10:30) will work or not?
i would like to compare the current date with the date entered by user..however, i'm encountering errors so far..
i tried something like this:
<asp:TextBox id="txtDate1" runat="server" /> <asp:CompareValidator runat="server" ErrorMessage="The date must be greater than today" ControlToValidate="txtDate1" type="date" ValuetoCompare="DateTime.Today.ToShortDateString()" />
and i got an error stating that the value of DateTime.Today.ToShortDateString() of the ValueToCompare property of "" cannot be converted to type 'date' i also tried ValueToCompare="DateTime.Now.Date()" and i got the same error message.
iam having two text box for password and confirm password in usercontrol i want to validate these control using compare validator in mvc whether any difference is there between the ordinary .aspx and .ascx while using this compare validator.
I have a compare validator datatypecheck that was set up to check the date entered. I am now changing this to check to make sure that the date/time entered is valid. I changed the binding to be the date and time. I am not seeing anything that I need to change on the compare validator.
When I run the program and enter a date and time into the textbox, it is giving me the error that it is an invalid date. What am I missing?
In my asp.net page I have two DatePickers, String Format. I want to use the Ajax Compare Validator but is'nt validating my dates correctly. I Want to Validate that my StartDate is Equal or Less than my End Date. The problem is that when I select the operator LessThanEqual it only work when The StartDate is Less than the End Date. IF StartDate is equal or Greater than the End Date is Displays the Error Message. I change it to all the possible options and it won't work as I want.
How to reset date Type for Compare Validator in ASP.Neti am using the dd/MM/yyyy format for the Calendar Extender of a textbox, where as Compare Validater looks for MM/dd/YYYY format.so how to change date format of Compare Validator.
All of the examples I can find show the compare validator being used to see if two values are the same. Validation is succesfull if these values are the same, such as password confirmation.I want validation to succeed if values are not the same. I want to use this to be sure that someone doesn't enter the same value for two phone number fields. I want the two values to be different. Can the compare validator be used for this? I wasn't able to find any properties or examples that used it in this way. If not, how should this be done?
<asp:CompareValidator ID="cpvBirthDate" Type="Date" ControlToValidate="txtBirthDate" Operator="DataTypeCheck" runat="server" ErrorMessage="Please enter a valid date in this format mm-dd-yy"> <img src="Images/ExclamationMark.gif" alt="Please enter a valid date in this format mm-dd-yy" /> </asp:CompareValidator>
It works on the clientside fine, but if a user has javascript disabled then it accepts 071873 which is not a date. Do I need to write a specific serverside function for this validator to work?