Is it possible to read a field which is text from a table and store the text value into a variable that can be used later?
Say the field is called “FiscalYear” and it contains this data “2016-2017”. How would I do this? Many of the examples I see
deal with numeric fields to be used with functions like SUM(), AGGR() and etc.
It is possible to insert a text in a input box that will overwrite a variable and then use that variable in a TextBox and every object you want. Hope this makes it clear
I followed your code. When I displayed the variable vMaxFiscalYear in a text object like:
= $(vMaxFiscalYear )
The text label shows a value of "2001". My actual data is "2017-16". What am I missing?