Is there any easy way to set the DATE_STARTOF to this financial year?
Our financial year is from the start of July through to the end of June.
The only way I found to do this was to set the date to the start of the year 2 years ago and then add 18 months onto that. Like this:
DATE_ADD((DATE_STARTOF(TODAY(),year,-2)), month, 18),
Is this the correct way to do it?