My mind is gone today.
Say I have a table like this
Foo
----------------------------------------------------------------------------------
FooID [int] PK | DateIssued [datetime] | Foo [varchar]| Bar [varchar]
How would I query to say "taking a random date find which
two dates you are between and take the lower datetime value
as the record to return"?
Say I have a table like this
Foo
----------------------------------------------------------------------------------
FooID [int] PK | DateIssued [datetime] | Foo [varchar]| Bar [varchar]
How would I query to say "taking a random date find which
two dates you are between and take the lower datetime value
as the record to return"?