[Resolved] range of dates in one field?

[FiveFlat]

I need a field that contains a range of dates. For instance if I request a job from a job board and the job board requires the job to be performed between 10/24 and 10/30 - How do I record that range?

and can the same be implemented with a time field?

[nemonoman]

It would be an exceedingly bad idea to try to capture 2 dates in a single field.

You'd do much better to create 2 column on your table:

startbydate
endbydate

Then you would

SELECT *
FROM someTable
WHERE startbydate>=current_date()

Or if the user were to provide
$startOfMyAvailabilty
$endOfMyAvailabilty

SELECT *
FROM someTable
WHERE startbydate>='$startOfMyAvailabilty'
AND endbydate <=$endOfMyAvailabilty'