return value from function Month(Today())

[janus2021]

Hi.
I do not know if the problem I am getting is due to some attitude in our environment or if I 
wrote something wrong in the code.
What is seen in the image is: 
Month which is a field in a column and must be matched against the function that is to pick up the current month. 
However, it gives no result due to the month from the function being apr.
The whole expression looks like this: sum( { 1<Month={"$(=Month(Today()) )"} > } LineSalesAmount)

Asks the question here so maybe someone can give tips what is wrong.

Regards.

[jwjackso · Accepted solution]

In your load script, are the MonthNames in lowercase?

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

[JuanGerardo]

Hi @janus2021, probably the fastest way to solve this is to configure the short names for moths. This can be done in the reload script, using the MonthNames variable, like in following sentence:

SET MonthNames='ene.;feb.;mar.;Abr.;may.;jun.;jul.;ago.;sept.;oct.;nov.;dic.';

Usually you can already find this variable at the beginning of any script.

JG

[rwunderlich]

I think you have an extra space that needs to be removed.

sum( { 1<Month={"$(=Month(Today()))"} > } LineSalesAmount)

[janus2021]

I didn't have this in the scriptT, when adding it did the trick for my problem:

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';