Using Relative Dates and App level variables
Hi all: I have what I think is a simple problem and I probably have even solved it in the past but would like some help advancing my skills. I have field that counts records when a particular date...
Forum Discussion
Melissa,
I believe global variables are always text fields. You would include your variable in a formula using the bracket notation [CurrentFiscalYear]
So the formula would have
var text fiscalYear = [CurrentFiscalYear];
var date start = ToDate(Part($fiscalYear,1,"-"));
------------------------------
Neil Schneider
------------------------------
I believe global variables are always text fields. You would include your variable in a formula using the bracket notation [CurrentFiscalYear]
So the formula would have
var text fiscalYear = [CurrentFiscalYear];
var date start = ToDate(Part($fiscalYear,1,"-"));
------------------------------
Neil Schneider
------------------------------