Personal, I need to do the following validation:
When a record enters my database, I need to validate the effective date of this record.
If the validity is between the current date then the record is valid.
Ex:
Effective 12/03/2015 to 03/13/2015, the validity expires on 03/13/2015 correct?
But I need to consider the final date until 03/03/2015 at 03:00 in the morning, after this time the final date will no longer be valid.
Does anyone have any idea how I can create this rule?