Bank Account Statement Date

Business Central/NAV Developers Forum
1

Hello, I am am writing a report from the bank account, and would like to bring in the last statement date on to the report. On the Bank account the “Last Statement No.” is 4 On the Bank Account Statement the last “Statement No.” is 3 How do I reduce the Last Statement No. by 1 in order to find the “Statement No.”? Is there an opposite function to INCSTR, or a better way to do this?[?] Regards Richard

2

Hi rsfairbanks To decrement a string by one: IF EVALUATE (LastStatementNo, “Last Statement No”) THEN BEGIN LastStatementNo := LastStatementNo - 1; “Last Statement No”" := FORMAT (LastStatementNo); END; Hope this helps David

3

Thank you David, Just what was needed!