Ugh. My first attempt to post this was apparently eaten by Safari. Thanks, Apple.
I am looking for a way to convert a date to another date, conditionally.
Basically, if the date is before July 1, I want to convert it to June 30 of the current year.
If it's after July 1, I want to convert it to June 30 of the NEXT year.
Does anyone have any guidance on this?