Hi, i need some help putting a variable into an expression.
In my script i create the following variable..
SET vCurrentYearFiscalStartDate =DATE(FirstDayCurrentFiscalYear);
then also in the script i am using this expression..
LET vItemCount_Listings =
'COUNT({$<
[it_target_type]={"Listings"},
[ld_Dist]={"4"},
[ld_Outlet_Check_Date]={">=01/07/2012 00:00:00"}>}
[ld_Item_Description])';
The above is hard coded with a date (01/07/2012 00:00:00), i want to replace this date with the variable created before it but i cant seem to get it working.
Can anyone help please?