Multiple dates for event posting

Forum|Forum|19 years ago
August 11, 2006
2 replies
631 views

I'm creating an application where a person can post an event with listings for up to 20 days from filling in the form. I'm saving these dates (one to twenty individual units, using a 20060810-type code, separated by a delimiter) in a single field.

I am trying to figure out how I can construct an efficient query to find a range within a set of date codes that answers the question "what is happening between 8/1 and 8/6" for example. I know how to find things by the day, of course.

Is this possible?

Advanced techniques

This topic has been closed for replies.

Correct answer Karen_Little

Over night, I've decided to handle the issue in another way (separate table), so my needs are resolved. That said, after overnight pondering on the subject, I do not think that the task could have been done through a single SQL statement. Thanks for offering to help!

A

Anonymous

> I'm saving these dates (one to twenty individual units, using a 20060810-type code,
> separated by a delimiter) in a single field.

Could you post the data from a field that has multiple dates in it?

Karen_LittleAuthorCorrect answer

Inspiring

Over night, I've decided to handle the issue in another way (separate table), so my needs are resolved. That said, after overnight pondering on the subject, I do not think that the task could have been done through a single SQL statement. Thanks for offering to help!

D

Dan_Bracuk

Inspiring

Normalize your database and then you'll be able to write efficient queries.

Karen_LittleAuthor

Inspiring

My database is normalized and I can easily find all the events on a specific date using the above method.

What I'd like to do is query the date list for a date that is greater than or equal to the requested date.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded