Greater Than or Equal To Today Date validation annotation in MVC3

53,645

Solution 1

Create a custom attribute.

public class CheckDateRangeAttribute: ValidationAttribute {
    protected override ValidationResult IsValid(object value, ValidationContext validationContext) {
        DateTime dt = (DateTime)value;
        if (dt >= DateTime.UtcNow) {
            return ValidationResult.Success;
        }

        return new ValidationResult(ErrorMessage ?? "Make sure your date is >= than today");
    }

}

code was written off the cuff so fix any errors :)

Solution 2

Use [Remote] for special validations, simple and easy:

Your model:

[Remote("ValidateDateEqualOrGreater", HttpMethod="Post", 
    ErrorMessage = "Date isn't equal or greater than current date.")]
public DateTime Date { get; set; }
//other properties

Your action:

[HttpPost]
public ActionResult ValidateDateEqualOrGreater(DateTime Date)
{
     // validate your date here and return True if validated
     if(Date >= DateTime.Now)
     {
       return Json(true);
     }
     return Json(false);    
}
Share:
53,645

Related videos on Youtube

CD Smith
Author by

CD Smith

Updated on October 13, 2020

Comments

  • CD Smith
    CD Smith over 3 years

    Has anyone seen an MVC3 data annotation for Date validation that requires a single selected date to be equal to or greater than current date?

    If there's already a third party add on that's cool too. I'm already using the DataAnnotationsExtensions but it doesn't offer what I'm looking for.

    There doesn't seem to be any reference of this on. So, hoping someone has already solved this before I try to reinvent the wheel and write my own custom validator.

    I've tried Range but that requires 2 dates and both have to be constants in string format such as [Range(typeof(DateTime), "1/1/2011", "1/1/2016")] but that doesn't help. And the DataAnnotationsExtensions Min validator only accepts int and double


    Update Solved

    Thanks to @BuildStarted this is what I ended up with and it works great server-side and now client side with my script


    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.Web.Mvc;
    
    namespace Web.Models.Validation {
    
        [AttributeUsage(AttributeTargets.Field | AttributeTargets.Property, AllowMultiple = false, Inherited = true)]
        public sealed class DateMustBeEqualOrGreaterThanCurrentDateValidation : ValidationAttribute, IClientValidatable {
    
            private const string DefaultErrorMessage = "Date selected {0} must be on or after today";
    
            public DateMustBeEqualOrGreaterThanCurrentDateValidation()
                : base(DefaultErrorMessage) {
            }
    
            public override string FormatErrorMessage(string name) {
                return string.Format(DefaultErrorMessage, name);
            }  
    
            protected override ValidationResult IsValid(object value, ValidationContext validationContext) {
                var dateEntered = (DateTime)value;
                if (dateEntered < DateTime.Today) {
                    var message = FormatErrorMessage(dateEntered.ToShortDateString());
                    return new ValidationResult(message);
                }
                return null;
            }
    
            public IEnumerable<ModelClientValidationRule> GetClientValidationRules(ModelMetadata metadata, ControllerContext context) {
                var rule = new ModelClientCustomDateValidationRule(FormatErrorMessage(metadata.DisplayName));
                yield return rule;
           }
        }
    
        public sealed class ModelClientCustomDateValidationRule : ModelClientValidationRule {
    
            public ModelClientCustomDateValidationRule(string errorMessage) {
                ErrorMessage = errorMessage;
                ValidationType = "datemustbeequalorgreaterthancurrentdate";
            }
        }
    }
    

    And in my model

    [Required]
    [DateMustBeEqualOrGreaterThanCurrentDate]
    public DateTime SomeDate { get; set; }
    

    The client side script

    /// <reference path="jquery-1.7.2.js" />
    
    jQuery.validator.addMethod("datemustbeequalorgreaterthancurrentdate", function (value, element, param) {
        var someDate = $("#SomeDate").val();
        var today;
        var currentDate = new Date();
        var year = currentDate.getYear();
        var month = currentDate.getMonth() + 1;  // added +1 because javascript counts month from 0
        var day = currentDate.getDate();
        var hours = currentDate.getHours();
        var minutes = currentDate.getMinutes();
        var seconds = currentDate.getSeconds();
    
        today = month + '/' + day + '/' + year + '  ' + hours + '.' + minutes + '.' + seconds;
    
        if (someDate < today) {
            return false;
        }
        return true;
    });
    
    jQuery.validator.unobtrusive.adapters.addBool("datemustbeequalorgreaterthancurrentdate");
    
    • Maksym Kozlenko
      Maksym Kozlenko over 11 years
      Server DateTime.Today and client side datetime could be different. I think you should be passing a server side time instead of using JavaScript new Date().
    • Maksym Kozlenko
      Maksym Kozlenko over 11 years
      Another issue is that you are assuming that client has US date settings (mm/dd/yyyy) (today = month + '/' + day + '/' + year + ' ' + hours + '.' + minutes + '.' + seconds;) It will not work in other locales.
    • CD Smith
      CD Smith over 11 years
      Good call, but we don't support any other locale than US
    • Maksym Kozlenko
      Maksym Kozlenko over 11 years
      Too bad. That means I won't be able to use your website :-( I've got en-AU locale on my desktop and ru-UA locale on my laptop.
  • Buildstarted
    Buildstarted almost 12 years
    I forgot, off the top of my head, how to make a javascript version. I'll have to check some old code for that if you're interested.
  • CD Smith
    CD Smith almost 12 years
    I considered that but that's not the direction I want to go, I'll need to create the client side jquery for it as well. Good suggestion tho!
  • CD Smith
    CD Smith almost 12 years
    I have a client side one I can adapt :-) Thanks!
  • Matija Grcic
    Matija Grcic almost 12 years
    No client side jquery is needed.
  • CD Smith
    CD Smith almost 12 years
    Not for the remote, I meant for the data annotation that I would prefer to use. I don't want a separate call to the server for it.
  • Matija Grcic
    Matija Grcic almost 12 years
    Why not, it's fast and simple. No need to make a custom attribute and register it in the global.asax. I use it all the time for specific validations.
  • CD Smith
    CD Smith almost 12 years
    Partly because I'm already using this strategy for all of my other custom validation, so I'm already registering them so the chosen pattern has now become our "required" pattern. So I don't want to get into mixing strategies when I already have one in place. It's a good suggestion tho, I'm not knocking it :-) Just not what I'm looking for
  • CD Smith
    CD Smith almost 12 years
    This is MVC with Razor not WebForms, server side controls aren't used.
  • jakejgordon
    jakejgordon about 8 years
    Access modified should be "protected" instead of "public" -- otherwise this works.