Thread: [Solved] Adding 9 months to month end date.
View Single Post
 
Old 10-24-2018, 02:08 AM
DanOnline DanOnline is offline Windows 10 Office 2016
Novice
  
Join Date: Oct 2018
Posts: 7
DanOnline is on a distinguished road
Default
Hi,

I have tried using the field given under "Calculate the day & date of the last or nth-to-last day of a given month"

With the ‘DATE’ expressions in the original fields to my date field. And the options set to subtract 0 offset 9. The result is the month 9 months in advance but the date is not always the last date of the month. I.e. 31 Jan 18 generates 30 Oct 18. 28/2/18 generates 30/11/18. 31/3/18 to 30/12/18 and so on. Is there a way around this?
Reply With Quote