Hi,I'm loosing the plot somewhat over this. Somewhere I've seen guidance which states how a date field can have its value increased by a number of months.
Basically I want to have two fields - a date field and a 'months' field, and once entries have been made in those, either when a 'Save' button is pressed or a refresh occurs on the form, for the new calculated date to appear in a new 'read only' field.
Unfortunately the approach of converting months into days (3 months would equate to approx. 91 days for example) and then adding that to the date field, isn't really good enough in this situation as I'm wanting to ensure we have the same date in the month regardless.
It's for use around reminders for payment dates and terms and so it has to be exact, therefore for example if we have a start date of 2nd Februay, and that should have 5 months added to it, it is essential that this becomes 2nd July in the calculated field.
I seem to remember that this guidance was on a page which held examples of calculating formula linked to dates. If anyone can either point me to information they know of which documents this, or can advise on the methods and approaches, I will be very grateful.
Regards - Merley72