fiscal year not working in open triger...?

[balasundaram]

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...

[#2]

try this

=maxstring(FiscalYear)

[tresesco]

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.

[aveeeeeee7en]

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

[Colin-Albert · Accepted solution]

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.

[balasundaram]

thank you..