date bucket script error

[didierodayo]

Hello,

I have 2 date fields and am trying to create a date bucket out of both.

I want the bucket to reflect

passed date - 'Now'

Today() and next 3months - '3m'
passed and next 3months -  '0-3m'
3month to 6months     -6m
passed and next 6months -  '0-6m'

6months  to 12 months    - 12m
passed and next 12months -  '0-12m'

12 months to 24 months    - 24m
passed and next 24months -  '0-24m'

24months to 36 months     - 36m
passed and next 36months -  '0-36m'

what will be the best way to achieve this giving I have to date fields to sort through?

I have attached a qlikview with my current method which is not working.

[didierodayo]

yes wrong doc . sorry. I have attached the correct ne now

[sunny_talwar]

Can you run the attached

[didierodayo]

They are loading up but the result is incorrect.

[sunny_talwar · Accepted solution]

Check out now

[didierodayo]

That once again Sunny your help is always appreciated. It is working now. Cheers