Multiple Dates In single cell

[Guest]

Am i limited to expressing only the one date in a particular cell? At present
i have the cell formatted in 'Date/Time' option. Would prefer to use some
kind of validation technique as opposed to formatting cell as 'Text'. Any
help or general comments would be a great advantage.

Thanks

 

[David F Cox]

I think the way you have expressed your question may be confusing. It could
be read as you are trying to put more that one date value in a single
"cell", which is a very bad idea.

Can you give an example of exactly what you are trying to achieve?

 

[Arvin Meyer [MVP]]

Databases do not have cells, the have fields and rows, the convergence of
which is an array of data. Regardless of any ability to do the contrary,
with any datatype you should never enter more than one instance of data in a
field for each row. With numeric fields, such as a date field it is not even
possible to do so. You can validate any field based on a criteria. If that
criteria includes another field, you may have to use a form (which you
should be anyway) and the BeforeUpdate event rather than a Validation
property, so that you can build a more complex evaluation.