2 dates in same record are being added together
When I have multiple dates in the same record displayed on a layout, the fields are being added. 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. My problem is the dates are used in calculations and this is throwing off my results. I know I could just create a record for each date but I need both dates (or muliple dates) to appear on the layout at the same time. How do I keep this from happening? Also, this is a single table DB - that displays the appropiate action which is determined by client and date.