Is there a way to automatically calculate a date 3 months from a specified date. I am trying to make a table with an inital assesment date then automatically fill in a 3 month follow up date.
Date function
(2 posts)-
-
Yes, there is a way to do this by creating a computed field. Keep in mind that since your assessment date will be in a table, the computed field MUST be added to the table as well. Otherwise, it will not work properly.
Create a new field. Name the field and select the type as 'Computed'.
The computed field expression will be similar to this:
DATE(MONTHS({Field}, 3))Note; To get your {Field} name, you will need to drag the assessment date field to the computed field expression box.
Click 'Test' to make sure that the expression is OK. Then click 'Add'.Now add this computed field to your table field. The 3 month date follow up date will automatically appear in the table for you to view.
Reply
You must log in to post.
