Start of this financial year (fiscal year)

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?

1 comment

  • 0
    Aqua Gardening

    Please disregard my formula above for this financial year, it is incorrect.

    I came up with the following formula instead. This formula sets the date to the start of July that has already passed. This is what I was looking for:

    DATE_STARTOF(TODAY(), year, 0, July)

Please sign in to leave a comment.