Date Comparison Issue-Set Analysis

[#1]

Hi All,

I am trying to give this expression in my pivot.

Is there anything wrong with the syntax?Especially the Join_Dt field.Other conditions are working fine .When i give the Join_dt condition its not working properly.

=SUM({<ACTIVE={1},DType={1} ,JOIN_DT={"<$(=(MonthEndDate))"}>}RNK)

[#2]

u can check the date format of both field

[datanibbler]

Hi Poornima,

yes, the syntax in the last part (that JOIN_DT thing) is wrong.

Set_analysis is quite tricky, but I will give it a try.

- What you want is to state that JOIN_DT should be before the MonthEndDate, right?

=> If so, this might work:

>>> =SUM({<ACTIVE={1},DType={1} , JOIN_DT = {"$(= '<' & MonthEndDate)"}>} RNK)

Best regards,

DataNibbler

[MK_QSL]

Try this

SUM({<ACTIVE = {1}, DTYPE = {1}, JOIN_DT = {“<$( =Monthend(Today()) )”}>}RNK)

[Anonymous]

Hello Poornima,

If your are tring to get the last day of the month, use:

sum( {<Date = {'<$(MonthEnd(21/10/2013))'}>} value ) 

Else, the syntax would be

sum( {<Date = {'<21/10/2013'}>} value ) 

Hope I could Help. See Attached

Regards

[#6]

Hi Poornima,

try this:

SUM({<ACTIVE={1},DType={1} ,JOIN_DT={"<$(=max(MonthEndDate))"}>}RNK)

Let me know if this helps

Rochelle