MadAtMicrosoft
Registered User.
- Local time
- Today, 14:53
- Joined
- Sep 27, 2010
- Messages
- 18
Hello again and thanks in advance to any responses.
On a Form I am attempting to use a Time field "StartTime" and perform the following IIf( (Between And)) in an Unbound txtbox
My starttime Field is set to (Medium Time)
Any idea on what I am missing?
On a Form I am attempting to use a Time field "StartTime" and perform the following IIf( (Between And)) in an Unbound txtbox
=IIf(([StartTime] Between #10:00:00 AM# And #11:59:00 AM#),1,2)
Regardless of any time values I insert into the function the Between And always returns the false value of 2 even if my StartTime Field is actually between the indicated times.
My starttime Field is set to (Medium Time)
Any idea on what I am missing?