Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm fond of the new syntax for set analysis and is experimenting to put set expressions into master items. At this point I also try to read these expressions from variables. I do see problems when creating such variable in script vs in variable area.
Example:
In script I create:
After script load I have the following variable in variable area, see picture. I have no problem, though, to CREATE such variable in variable area (even if the syntax check complains) and use it accordingly in my application.
So there is a solution but I do prefer creating variables in script for reuse and source control. Is there a script solution to make the variable to 'stay' as defined in the SET creation? I do have tried many different syntax alternatives but they all end up as:
It is the expansion of $(vMaxDateMonthEnd) that ruins my day. 😎
Hi, try it like this instead:
SET vMaxDateMonthEnd = '=MonthEnd(Date(Max(Datum)))';
LET vSA_MaxDateMonthEnd = REPLACE(REPLACE('{<Källa={‘ANST_Månad‘}>},{<Datum={">=#(vMaxDateMonthEnd)"}>}','‘',CHR(39)),'#','$');
Hi, try it like this instead:
SET vMaxDateMonthEnd = '=MonthEnd(Date(Max(Datum)))';
LET vSA_MaxDateMonthEnd = REPLACE(REPLACE('{<Källa={‘ANST_Månad‘}>},{<Datum={">=#(vMaxDateMonthEnd)"}>}','‘',CHR(39)),'#','$');