Showing UnKnown error in script loader

[berryandcherry6]

HI,

i have below code

LOAD

campaign_id

RESIDENT CAMPAIGN where campaign_start = Date(Num(Max(campaign_start, 2))) and match(camp_batch_meta_data_id ,24);

here i am trying to retrieve 'campaign_id '  where  camp_batch_meta_data_id  = 24 and campaign_start  date will be  2nd largest in table.

If i load this i am getting Unknown error.

What i am doing wrong. Please help me on this

Update: Please check Sunny's answers. This can be done both in load editor and front end as per requirement. Both works fine.

[sunny_talwar]

May be like this:

Sum({$<batch_meta_data_id={'42'}, campaign_redirect_start = {"$(=Date(Max({1}campaign_redirect_start, 2), 'DateFieldFormatHere'))"}>} landing_hits)

[berryandcherry6]

Hi Sunny,

This worked, this will be less code, so i go with this rather then using long loading script in load editor

Thanks