Date and Time Validation [message #497752] |
Mon, 07 March 2011 01:12 |
rahshar
Messages: 26 Registered: July 2006 Location: Oman
|
Junior Member |
|
|
Dear All,
I have a Situation for Date and Time Validation.
I have 4 fields, d1,d2,t1,t2 all are date datatype
I have 1 field for R1 for resource a varchar datatype
1. d1 and d2 for date
2. t1 and t2 for time.
The User enter d1 and d2, t1 and t2
eg 01-03-2011 - > d1
01-03-2011 - > d2
9:00 - > t1
9:30 - > t2
and 'Room1' - R1 for resource.
any other entry having the same data, or have partial data should not be allowed.
like on 01-03-2011 between 9:29 to : 9:40
or even 8:30 to 9:01 on the same date or (replicated dates boundaries) should not be allowed.
How can we achieve this.
Any one has done this exercise.
Thanks in Advance
|
|
|
|
|