Created Current Month, Last Month Buckets

Anonymous — Mon, 29 Jan 2018 14:29:56 GMT

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

Re: Created Current Month, Last Month Buckets

sunny_talwar — Mon, 29 Jan 2018 14:32:05 GMT

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