Multiple dates for event posting

Question

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?

Karen_Little · Accepted Answer

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!

Anonymous · Answer

> 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 datesin it?

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.