topic Re: Sum Expression how to insert a month(today()) function in Connectivity & Data Prep

Sum Expression how to insert a month(today()) function

Wimmer-Logistik — Fri, 10 Dec 2021 21:09:00 GMT

Hi,

i have this simple expression in a sum formula which works fine:

{$<vYear={"2020"},vMonth={"<=7"}>}

How can i replace the 7 with the current Month?'
I tried:

{$<vYear={"2020"},vMonth={"<=(=Month(Today())"}>}

The editor says OK, but the result is zero in other words, not the same as above.
What am i missing here?

rubenmarin — Wed, 07 Jul 2021 07:10:29 GMT

Hi, try with: {$<vYear={"2020"},vMonth={"<=$(=Num(Month(Today())))"}>}

Wimmer-Logistik — Wed, 07 Jul 2021 07:13:35 GMT

Hello,

works FINE!! Thanks !!

bye!