Please Help

[#1]

Hi !!

Problem I am facing is -

As per Scenario i have pasted Below - current date [take 04/01/2014] and here SPD date is [25/08/2014] , which  makes member non eligible, because member's SPD Date Falls under Last Six Month From Current Selection.

Please Help me In Logic To Rectify Eligible and Non Eligible.

301028

2585906

Pragya Sinha

Lucknow

Active

0

0

33200

0

6/1/2015

10

8/25/2014

No

25 - White STU

White

Studio

Noida

201301

9.2E+11

0

Not Eligible

Thanks In Advance.

[Anonymous]

That should be a relatively simple if statement

if SPD date is less than current date minus 185.5 then Non Eligible else Eligible