Date from the 1st of month 3 months ago

[JamieH]

I have a date table and would like to have a "Y"/"N" column in there that indicates if the DATE was within the last 3 calendar months, starting from the 1st of the month. 

For example, where today is October 13, I would like every day from July 1st to today to have a "Y" with every other date being a "N". 

Can someone please advise?

Thank  you

[Greg_Deckler · Accepted solution]

@JamieH Try:

Column =
  VAR __Today = TODAY()
  VAR __ThreeMonthsAgo = EOMONTH(__Today,-3)
  VAR __ThreeMonthsAgoStart = DATE(YEAR(__ThreeMonthsAgo),MONTH(__ThreeMonthsAgo),1)
RETURN
  IF([Date] >= __ThreeMonthsAgoStart,"Y","N")

[JamieH]

Thats great.  Thanks Greg