2022-08-01 is the date format in the data field "Month"
what formula could I use to pull data for last 6 month only?
Thank you
@bh1789 See if this works
[Date] >= DateTimeFormat(DateTimeAdd(DateTimeToday(),-180,'days'),'%Y%U')
You can also use month in DateTimeAdd to subtract six months. This goes back 6 months from the first of the current month
[Month]>=DateTimeAdd(DateTimeFirstOfMonth(),-6,"month")