How to use variables?

[#1]

Hello, can someone point me out how to declare and use variables?

I was trying to achive something like

SET FirstDayOfTheMonth = Today();

SQL SELECT * FROM MyTable Where Date = FirstDayOfTheMonth

But Im getting an error that says "FirstDayOfTheMonth" field cannot be found.

Thank you ,

Jose.

[Miguel_Angel_Baeyens · Accepted solution]

Try expanding that variable such as

SQL SELECT * FROM MyTable Where Date = $(FirstDayOfTheMonth)

That should work.

[avastani]

Let FirstDayOfTheMonth = Today();

SQL SELECT * FROM MyTable Where Date = '$(FirstDayOfTheMonth)';

[#4]

LET is used with expressions and SET with values.