Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to get current_campaign_id based on batch_meta_data_id and current_start_date.But here i am not able to get anyvalues when i put this expression inside textbox.
current_campaign_id = p({<batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY'))"}>})
even i tried on this
Concat({current_campaign_id = p({<batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY'))"}>})
>} current_campaign_id, ', ')
but no luck
Please help me on this.
Thanks,
Supriya
Try this
Count({$<DateType= {'completion'}, final_test_status={'passed'},
current_campaign_id = p({<batch_meta_data_id = {'23, 24'}>}current_campaign_id ), current_start_date = {"$(=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY'))"}>})
>} invitation_id)
Hi,
Thanks for your reply
This gives me zero counts.
I think '>}' should be removed in your answer.
Have you checked if you even have data for the those combination in your database?
Hi sunny,
yes,i have checked i have values for those combination.
Will you be able to provide a sample so that we can take a look at the issue?
!Hi,
Thanks for your reply !
Please look at attached sample in original post
I don't see any current_campaign_id where date is 5-17-2016 and batch_meta_data_id = 23 or 24
I have a feeling that you are not working with the incorrect date here? Are you sure you want this
=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY')
or another date which is not based on Today(), but based on current_start_date
Hi,
Don't take campaign_start_date,take current_start_date or start_date in CAMPAIGN table.
I am comparing current_start_date in CAMPAIGN table with =Date(WeekStart(Today()) + 1, 'MM-DD-YYYY').
Because start date(or renamed as current_start_date ) indicates start date of campaign.
Here i am trying to get campaign_id which started this week(as every campaign starts on tuesday of every week ,i am comparing weekstart with start date in CAMPAIGN table) and which are based on batches 23 and 24.