Insert A Range Of Date

[kbsudhir]

Hi Guys,

I want to insert a range of date in a field i.e "SchDates".

The data will be like this 27-28 or 20-30 or something like this.

I can't enter the same in date/time format as the formt is not current.
I am using text format to insert data to in the filed.

If I use Text format I can do teh validations.

ex I want to check if 27-28 range is coming between of 20-30 range.

I want to how to go about doing this.

:banghead: :banghead:

Thanks
Sudhir

[CreganTur]

One option I can think of is to use 2 different fields- a start date field and end date field. Then you could use SELECT CASE statements to evaluate.