Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm adding new variables to the QV Components date variables.
Because I want to use a date island I tested in the GUI for the correct syntax and want to add this as new variables.
I want to create this new variable:
// Year To Date Productief Date island
Let $(_fieldPrefix)vSetYTDModifierProductiefDateIsland =
MapSubString('_qvctemp.Calendar.EscapeCharsMap',
'$(_vClearFieldList)
$(_f_DateSerial) = {">=$(=min(_DateIslandSerial))<=$(=max(_DateIslandSerial))"},
$(_fYear) = {"@(=$(_qvctemp.vMaxModifier)$(_fYear)))"}
,$(vProductieveUren)
'
);
Adding a new part in the variabel ,$(vProductieveUren) works as needed but I cannot get the DateIslandSerial part working.
The variable resolves in the fron end to >=<=.
I tried this:
$(_f_DateSerial) = {"@(>=$(=min(_DateIslandSerial))<=$(=max(_DateIslandSerial)))"}
and I tried placing the whole part {">=$(=min(_DateIslandSerial))<=$(=max(_DateIslandSerial))"} into another variable but the result remains the same.
Q: how do I need to format this part to resolve in the variable?
I'm using QV Components 10.1.
Try this one: $(_f_DateSerial) = {">=@(=min(_DateIslandSerial))<=@(=max(_DateIslandSerial))"},
have tried using Date# function like below, date format should be same as $(_f_DateSerial) and $(_f_DateSerial) should be in proper date format
{">=$(=min(date#(_DateIslandSerial,'DD/MM/YYY')))<=$(=max(date#(_DateIslandSerial,'DD/MM/YYYY')))"}
Change the format doesn't do anything.
The result I see in the variable is still >=<=
The DateIslandSerial isn't visible at all.
Try this one: $(_f_DateSerial) = {">=@(=min(_DateIslandSerial))<=@(=max(_DateIslandSerial))"},
Gysbert, can you explain what happens with the $ and @.
Is this the escape character mapping?
Yes, that's right.