Now between 2 times - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Now between 2 times

Keith Stanton

3 years ago

Hi All, I have been trying unsuccessfully to find a way to do the following.

Use a query or VBA code that can determine if the time value of Now() is between 2 time values of a start time and end time field. StartTime and EndTime fields are Date/Time fields. These times will be on same day, not bridging multiple days.

Does anyone have some pointers..or better yet a working solution?

Regards,
Keith.

	Adam Schwanz @Reply 3 years ago
QueryExpression: IIf(Now()>[StartTime] And Now()<[EndTime],"Yes","No")

	Keith Stanton OP @Reply 3 years ago
Hi Adam, Thank you. That kind of works. But it takes dates in to the equation. I am trying to do it without dates in involved. Trying just to work with times and not dates. X: IIf(TimeValue(Now()>[StartTime] And TimeValue(Now()<[EndTime],"Yes","No"))

	Adam Schwanz @Reply 3 years ago
TimeValue(DateField)

	Adam Schwanz @Reply 3 years ago
IIF(TimeValue(Now())>TimeValue(StartTime) If you don't need TimeValues on the starttime/endtime just omit those. Edit: Won't let me post the full code lol, put just do the same thing to the end part

	Keith Stanton OP @Reply 3 years ago
Perfect, That seems to be working. Thank You!! IIf(TimeValue(Now())>TimeValue([StartTime]) And TimeValue(Now())<TimeValue([EndTime]),"Yes","No")

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View