I have merg field showing an invoice number. I want to do the same or a calculation showing the last two numbers of the year.
I guess you have an invoice date field in your table? You can just insert the date as a merge field on your layout and then use a custom format that will hide everything except the year that you will choose to show with only the 2 last numbers :
And else, if you have the year only as a number field, you can create a calculation field that will do the following : Right ( year ; 2 )
You can then insert that calculated field as a merge field on your layout and it will always show the 2 last numbers of the year field.
Great advice, Thomas! Keep in mind that if you have several "number-type" fields as merge formatted AND other text, you may run into problems if you format the block of merge text and fields. The Inspector settings will honor ONE number format, ONE date format. So if you have, for example:
Invoice Number field
Date field (even calculated to two digit number for year)
(all inside other text)
... applying currency will change all numbers (merge fields) in the block.
So, you have to be careful!
Often, I will calculate the text for the entire block and format with functions rather than Inspector formatting. Place that as your merge field.
Sent from miPhone
Retrieving data ...