0

Start of this financial year (fiscal year)

Aqua Gardening

January 02, 2020 02:04

None

Follow

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?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Aqua Gardening January 03, 2020 00:47

  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)