Calculated date returns a number rather than a date
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.......
Select Date as the return type instead of Number. There's a drop down in the lower left corner of Specify Calculation where you select that option.