Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have filed like
FiscalYear
2013-2014
2014-2015
i written condition in trigger
Doccument Trigger:
OnOpen->select in field action-->
filed: FiscalYear
search string: =Max(FiscalYear)
but not working...
max() selects the maximum numeric value, maxstring() selects the maximum text value.
Your fiscal year is defined as '2013-2014' so is a text value, therefore you will need to use maxstring(FiscalYear).
Another option is to define the financial year as a dual field, then max() will work.
try this
=maxstring(FiscalYear)
Check the output of Max(FiscalYear) in a textbox. That is possibly not generating a similar to FiscalYear format output. It could give you a single year like 2014 or 2015. Therefore,the search string could possibly not matching with field value and your trigger doesn't work properly. Share your sample qvw to be helped specifically.
Hi
Create a new field in Backend Script. Like this
Purgechar(FiscalYear,'-') AS New_FiscalYear
After Reload use this field in Trigger.
Create Trigger > Select in Field: New_FiscalYear > Search String: Max(New_FiscalYear)
It will give you the Max Fiscal Year.
Regards
Av7eN
max() selects the maximum numeric value, maxstring() selects the maximum text value.
Your fiscal year is defined as '2013-2014' so is a text value, therefore you will need to use maxstring(FiscalYear).
Another option is to define the financial year as a dual field, then max() will work.
thank you..