Need Help with Variable

[Anonymous]

Hi Guys

I am trying to put n a Variable but do not know how to do this.

I want a Flag if in the last 4 months CreatedDate was more than 4 months old to say Y and Older than 4 months to say N

I have attached a Test Script.

I can normally do this with months but this time the format is in DD/MM/YYYY so havent done this before.

Please see attached Qvw.

Thanks for the help!

[swuehl · Accepted solution]

Are you looking for

Let vTest = AddMonths(Today(),-4);

?

CreatedDate	DCF	Flag
01/10/2015	1	N
01/11/2015	1	N
01/12/2015	1	Y
01/01/2016	1	Y
01/02/2016	1	Y
01/03/2016	1	Y

[maxgro]

Let vTest = addmonths(today(1),-4);

maybe you have to chabge the test from this

If(CreatedDate >= '$(vTest)','Y','N') as Flag,

to

If(CreatedDate >= '$(vTest)','N','Y') as Flag,

[Anonymous]

Thanks Buddy!