Created Current Month, Last Month Buckets

[Anonymous]

I want to create a new field in my load script that takes a date (MM/DD/YYYY) and puts it in a current month, last month, etc .. bucket

Also wonder if I can do this with rolling weeks ... i.e make a new field that says, last 4 weeks, last 8 weeks, last X weeks ...

Thank you,

- dave

[sunny_talwar · Accepted solution]

You should be able to do like this

If(Date >= MonthStart(Today()), 'Current Month',

If(Date >= MonthStart(Today(), -1), 'Last Month')) as Flag

Similar idea should apply for weeks