selecting particular column values based on two column values in a single table

[berryandcherry6]

Hi all,

CurrentCampaignData:

Load

Batch_ID,

Campaign_ID as Current_Campaign_ID

Resident CAMPAIGN Where (current_start_date = Date(weekstart(Num(today()))+1));

I have created a table called CurrentCampaignData ,now i want to put expression for this so that i could retrieve Current_Campaign_ID based on Batch_ID and  current_start_date = Date(weekstart(Num(today()))+1).

i am using below expression but getting invalid expresion.

if((Batch_ID = {23,24} and current_start_date = Date(weekstart(Num(today()))+1)),Current_Campaign_ID)

or  is it possible to fetch datas  or is there other way?Any suggestion are welcomed

Please help me in this regard

Thanks,

Supriya

[Gysbert_Wassenaar]

Please don't clutter this site with duplicate discussions: expression for getting Campaign_id based on batch_id and date