Current YTD Flag creation for an odd start and end date

[ashleywooldridg]

I am trying to get a current year to date flag set-up for a Master Calendar.

The issue I have is that the start date for the trade year is 28th August.

I cannot seem to find anything that will allow me to have the 28th August as the start day for the current YTD.

Is there a way I can define the 28th as the first day of the new calendar year and any date after that until today's date is flagged as a 1?

Thank you

[sunny_talwar · Accepted solution]

May be this

If(TempDate >= (YearStart(Today(), 0, 😎 + 27) and TempDate <= Today() 1, 0) as Flag

[ashleywooldridg]

Thank you Sunny,

If(TempDate >= (YearStart(Today(), 0, 8)) + 27 and TempDate <= Today(), 1, 0) AS Flag

Works perfectly.