How to get Incremental month.

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

How to get Incremental month.


Hi,

I am currently facing issue in creating an incremental month.

I am creating a variable name DOB_MONTH.

I run bithday campaign for the customers whos birthday is in the coming month. ie in the month of Dec i run campaign to the customers whos birthday in Jan

I was using below function to get the birthday month.

DOB_MONTH=Month(today(()+1

It worked fine till last month, this month when iam trying to fetech the data it is throwing error. As per the logic it is searching DOB_MONTH 13 rather than DOB_MONTH 1.

Please suggest me the right logic.

Thank you,

Jiby Jacob


Accepted Solutions
Solution
‎12-06-2012 11:00 AM
Super Contributor
Posts: 1,636

Re: How to get Incremental month.

Posted in reply to jacobjiby

Hi,

try:

dob_month=month(intnx('month',today(),1));

View solution in original post


All Replies
Super User
Posts: 19,770

Re: How to get Incremental month.

Posted in reply to jacobjiby

Use intnx instead.

dob_month=month(intnx('month', today(), 1));

New Contributor
Posts: 3

Re: How to get Incremental month.

Thank You Reeza..It was really helpful....

Solution
‎12-06-2012 11:00 AM
Super Contributor
Posts: 1,636

Re: How to get Incremental month.

Posted in reply to jacobjiby

Hi,

try:

dob_month=month(intnx('month',today(),1));

New Contributor
Posts: 3

Re: How to get Incremental month.

Thank you Linlin...it worked..

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 285 views
  • 0 likes
  • 3 in conversation