AnsweredAssumed Answered

2 dates in same record are being added together

Question asked by JKH on Apr 6, 2011
Latest reply on Apr 6, 2011 by philmodjunk

Title

2 dates in same record are being added together

Post

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.

Outcomes