Max Function and Dates
I have a max function that returns the "highest", or most recent, date. However, what gets returned is the max date minus 1 day.
For example, the highest date is 4/20/2014. But 4/19/2014 is returned.
Is this a bug? Or how can I fix it?
We're not aware of this being an issue. When we tested the formula on our end everything functioned as expected. We recommend submitting a support ticket so that we can better analyze your specific issue in greater detail.