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