What do these dates represent?
The simplest way to record a flexible number of items of the same type of data is to use a portal to a related table where you can have a separate related record (portal row) for each time you choose to record such data.
For example, today is the 96th day of 2011 - when I show 2 or more dates the field contents are "9696", or 2 occurences of todays date displayed as Day of Year.
What do you mean by "show 2 or more dates"? How does the "9696" get entered into this field? By an auto-enter calculation? A Script? or?
BTW, if the day number is useful to you, that can be calculated as you are doing, but it is not necessary in order to compute the number of days between dates.
Hey Phil, appreciate your time. The table has client and dates. Each client has 3 date fields that represent 3 different status levels. (Holiday, Extended Processing or Hold Open) When I look at my layout the DB tells you the date, DayofYear, and if any of these 3 status levels are current. (Like today is a holiday for Client x) Yes, the DayofYear is an autocalc. If on a given day a client fits into more then 1 of these fields, I am getting the "9696" The "9696" is - today this client fits into 1 status, and then it fits into a second status - so you have under DayofYearAsNum 96 for the first condition, then 96 for the second. If a client met all 3 conditions the DayofYearAsNum would incorrectly read "969696". Your first comment confused me a little. All this info is static, it won't change untill 2012.
Please post the calculation expression you are using.