Return to FileMaker.com
editing specific number within a field?
I have a field containing bank statement numbers in the format of statement number/year...example "163/10"
I would like a way to calculate the previous bank statement number...using above example, I would like to show statement "162/10"
How can I achieve this?
Thank you for any help. Very much appreciated!
Well, you could try something like =
Let (v = Substitute ( StatementNumber ; "/" ; ¶ );GetValue ( v ; 1 ) - 1 & "/" & GetValue ( v ; 2 )) But this will not work for the first statement of the year.
But this will not work for the first statement of the year.
Retrieving data ...