1 Reply Latest reply on Sep 25, 2012 3:22 PM by philmodjunk

    Calculated date returns a number rather than a date

    jackmac

      Title

      Calculated date returns a number rather than a date

      Post

           Think this might be an easy one for someone...

           I have a field which has a date in it called 'Start'.  I have another field I want to populate called 'End'.  The contents of 'End' are 'Start' + 30 days.

           I created a calculated field and put Start + 30, the answer appeared showing a huge number.  (I know this is the number of days from the computer 'beginning date' until the given date)

           All is want is that if 'Start' shows 1 October 2012, I want end to say 31 October 2012 and not 7.......

           Any ideas?