Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?