Creating a variable from another variable

[ZimaBlue]

Hello!

I have a variable that is a date. I want to create another variable, which will be the month from the date in this variable. I try

=Month($(vDateFrom))

, and different variations of it (including even explicit conversion to date via Date#), but it absolutely doesn't work.

How to perform this simple action?

[hic · Accepted solution]

The $(...) construction is a macro expansion, which means that if you write
=Month($(vDateFrom))
the parser will see
=Month(1.12.2021)
which is an incorrect syntax.

Try
=Month('$(vDateFrom)')
or
=Month(vDateFrom)

[ZimaBlue]

It works perfectly! Thanks a lot, I really didn't think to try this option. Thanks!