Date issue

upaliwije — Thu, 28 Feb 2019 08:42:47 GMT

Hi Friends

I have written under mentioned script in my data load

IF(Num(YEAR(CEN_CL_LOSS_DATE))& num(MONTH(CEN_CL_LOSS_DATE))=Num(YEAR(CEN_CL_INT_DATE))& num(MONTH(CEN_CL_INT_DATE)),'SAME_MONTH',
IF(DATE(AddMonths(CEN_CL_LOSS_DATE)=DATE(AddMonths(CEN_CL_INT_DATE,-1),'LAST_MONTH'),'OTHER_MONTHS'))AS PERIOD,

But it does give a error message with

"Error in expression:AddMonths takes 2-3 parameters"

Kindly help me to solve the issue.

My requirement is if Month & Year of CEN_CL_LOSS_DATE= month & year CEN_CL_LOSS_DATE it should be categarised as same month. If the two fields are not equal by 1 month it should be 'Last Minth' otherwise 'Other Months'

Re: Date issue

MindaugasBacius — Thu, 28 Feb 2019 09:14:10 GMT

I guess the problem lies in this part of the sentence:

IF(Num(YEAR(CEN_CL_LOSS_DATE))& num(MONTH(CEN_CL_LOSS_DATE))=Num(YEAR(CEN_CL_INT_DATE))& num(MONTH(CEN_CL_INT_DATE)),'SAME_MONTH',
IF(DATE(AddMonths(CEN_CL_LOSS_DATE, 0)=DATE(AddMonths(CEN_CL_INT_DATE,-1),'LAST_MONTH'),'OTHER_MONTHS'))AS PERIOD,

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/addmonths.htm

topic Date issue in QlikView

Date issue

Re: Date issue