AnsweredAssumed Answered

How to calculate last day of month

Question asked by bokenrosie on Sep 12, 2017
Latest reply on Jan 18, 2018 by user26871

I have a field called "LastDay" that I would like to calculate to be the last day of the month based on another field "SaleDate".

 

I found something that says the following but cannot figure out how to implement.

This example assumes a date field called DateField.

LastDay (calculation, date result) =
Date (Month (DateField) + 1, 0, Year (DateField))

 

Where do I put the calculation?  Thanks

Outcomes