set analysis for date ranges

[#1]

Hi,

          I am writing a set analysis for data on policy count between some date range but not getting it working. Attached is the screen shot for the set analysis.

The Date function is getting a red underline.

Thanks

Lax

[CELAMBARASAN]

Hi,

     use like this,

     Count({<POLICYCURRENTSTATUS={'Withdrawal'},ELIGIBILITY_DATE={">=$(=MonthStart(EXTRACTIONDATE))

<=$(=MonthEnd(EXTRACTIONDATE))"}>} Distinct POLICYNUMBER)

Hope it helps

Celambarasan

[#3]

Hi, How do I put a variable vEDT instead of EXTRACTIONDATE into this set analysis.

Thanks

Laxmikant

[CELAMBARASAN]

Hi,

     Check with this,

     Count({<POLICYCURRENTSTATUS={'Withdrawal'},ELIGIBILITY_DATE={">=$(=MonthStart($(=vEDT)))

<=$(=MonthEnd($(=vEDT)))"}>} Distinct POLICYNUMBER)

If not working then tel whats you expression in variable?

Celambarasan

[jagan]

Hi,

Try this expression

=Count({<POLICYCURRENTSTATUS={'Withdrawal'}, ELIGIBILITY_DATE={">=$(=MonthStart(vEDT))

<=$(=MonthEnd(vEDT))"}>} Distinct POLICYNUMBER)

Regards,

Jagan.

[#6]

Hi, thanks for your input but both the scripts are failing, I still don't see any data.  The variable is having expression as max(extractiondate).  I am having enough data in this range but some how the script is not able to read.

I tried puttin single quotes as well but still same results.

Regards

Lax

[jagan]

Hi,

Can you attach the sample.

Regards,

Jagan.

[#8]

Hi, Please find the sample doc.

Regards,

Lax

[CELAMBARASAN]

Hi,

     Use your variable expression as =Max(EXTRACTIONDATE) instead of Max(EXTRACTIONDATE).

Celambarasan

[#10]

Hi,

     it is =Max(EXTRACTIONDATE), still doesn't get it right. Can you attach the corrected doc.