Problem With Multiple Date Columns

[bvssudhakar]

Hi Experts,

Here I am attaching qvw file. Please find it.

I have multiple date columns. I have combined and linked master calendar. Now I want to create Text Objects

I have create 1 Text object with this expression:

=Count(DISTINCT{<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'plcdate'}>}CandidateID)

This is giving Correct Output

I have 4 Text Objects remaining to create like this

2nd i tried with this expression

=Count(DISTINCT{<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'offerDate'}>}CandidateID)

But it is giving the out put 0 when i am selecting 2016 or 2017 or 2018...........

Why it is giving like this i am not understanding i have linked with offerdate column also

Can you guys please check the script and help me out from this

Thank you in advance

[Frank_Hartmann]

Sorry my previous post was not correct. e.g. the Dates for offerdate was not recognized as a Datefield and therefor the connection to the MC was not established! My previous post was concerning the first script i have posted but that was my mistake 🙂

[bvssudhakar]

Thank you

[bvssudhakar]

Hi Frank,

Can you please tell me how to convert that master calendar as hierarchy calendar. What changes are required