nested smart values issue

Anna_lpl1dr

Hi there,

I have checked many posts here and seems to write my smart value correct however, output is blank.

My first variable: {{vicDay}} is defined as

{{now.format("YYYY")}}-05-25

My second variable: {{vicDateDay}} is defined as

{{vicDay.toDate.DayOfWeek.minus(1)}}

Both variables return values in the log: as 2024-05-25 and 4 respectively

Now, I use the numeric value in my third variable: {{vicDayFinal}} defined as

{{vicDay.toDate.minusDays(vicDateDay)}}.

When I type in numeric value in the formula {{vicDay.toDate.minusDays(4)}} it returns 2024-05-20 as expected, when I use vicDateDay variable name then it returns null. The log shows that vicDateDay is Numeric.

Here is the log:

vicDay - 2024-05-25, vicDateDay - 4, vicDayFinal - , isNumeric - true, isAlpha - false

 

Anybody please help me on this.

 

Thanking in advance.

Bill Sheboy

Hi @Anna 

What problem are you trying to solve by doing this?  Knowing that may help the community to offer alternative solutions.

Until we know that...

Created Variables are text.  When you want to use them in a function such as minusDays() they must be converted with asNumber:

{{vicDay.toDate.minusDays(vicDateDay.asNumber)}}

Kind regards,
Bill