Date function

[bhavvibudagam]

Hi,

I need to condier the data after 1/12/14.

So i have given his in the expression as

CDTS_DATE is in the format of MM/DD/YYY.

iTS NOT TAKING THE PERIOD CORRECTLY.Please let me know whats wrong in the below expression

=IF(NUM(CDTS_Date) > NUM(DATE(MAKEDATE(2014,01,12),'MM/DD/YYYY')),$(vCFS)

-Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'SPECIAL'},CALL_SUB_TYPE={'OIL'}>}EID)-

Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'STATION'}>}EID))

Thanks,

[sunny_talwar]

How about this:

=If(CDTS_Date > MakeDate(2014,1,12),

$(vCFS)

- Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'SPECIAL'},CALL_SUB_TYPE={'OIL'}>}EID)

- Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'STATION'}>}EID))

[bhavvibudagam]

Hi Sunny,

Not getting.Please find the attachment of cdts date format.

Have taken the CDTS_DATE Field from CDTS.

[sunny_talwar · Accepted solution]

Do you have CDTS_Date as your dimension? If not, then try using set analysis or if statement within the Count function

Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'SPECIAL'},CALL_SUB_TYPE={'OIL'}>} If(CDTS_Date > MakeDate(2014,1,12), EID))

or

Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'SPECIAL'},CALL_SUB_TYPE={'OIL'}, CDTS_Date = {"$(='>' &  Date(MakeDate(2014,1,12), 'MM/DD/YYYY'))"}>} EID)

[bhavvibudagam]

Yes working fine Thank you

[sunny_talwar]

Awesome