Variable behaves differently on Server

[#1]

Hi.

I am baffled. I've got a variable that works fine on my desktop and on a staging server, but once on the production access point, the variable comes up null (using the same data and filters.

The variable's name is vQBRFYstartMonthDate, as is defined as:

=Addmonths(IF($(vQBRFYstartMonth)=1,

NUM(makedate($(vQBRDYselectedYear),$(vQBRFYstartMonth)+11)),

NUM(makedate($(vQBRDYselectedYear),$(vQBRFYstartMonth)-1))),-11)

This returns a date.

On the server, the variable fails, but the funtion works find. Yet on my local file and on a staging server, the variable works fine.

What give? I hope I am not overloking something silly...

[Clever_Anjos]

Let me ask a silly question

All others variables are set?

vQBRFYstartMonth

vQBRDYselectedYear

vQBRFYstartMonth

[#3]

Yes (One can never be too silly)

I have tested all three separately and they work fine, but anyways, the entire line works fine when called dirrectly, It's the variable that is failing (but only on the server). I have also tried to call the variable three different ways:

=vQBRFYstartMonthDate

=$(vQBRFYstartMonthDate)

='$(vQBRFYstartMonthDate)'

[Clever_Anjos]

Where are using this variable? Try to put

=vQBRFYstartMonthDate into a textbox and check what it returns

[#5]

Thanks how I am testing them. i.e by putting them in a text box.

[Clever_Anjos]

Did you try both plugin and ajax?

[#7]

Hadn’t tried Ajax. But I just did and it is the same problem.

[Clever_Anjos]

I can´t see a reason.

The app is exactly the same? Or into your prod server you´ve reloaded the app?

[#9]

I am not sure I understand but I think the app is reloaded, since I am pushing a full qvw file to the server.

[Clever_Anjos]

If you copy your production qvw and open it using your desktop, the issue persists?