Hi to all,
I am creating a custom print format (in Version 5) and all works fine by now.
Now I have some details to insert to the print format. Is there any formating option to convert data of an existing document/doctype? I dont want to change the underlaying data, just the representation in the print format.
For detail:
- I like to get any date of my document and present it as follow: Munich, the 6. of Juli, 2015 (or just 06. Juli 2015)
- I like to change the presentation of the price (change 1,000.50 to 1.000,50). Using the formated value doesn’t give me the needed format back so I like to change it by myself.
- I like to cut a part of an existing value for needing less space. Example: Having my unique number (doc.name) RE-2015-123456 (to make the invoice uniqe within a year) and I only like to display the number part. This is just an example of what I like to do.
Are there any formating options like:
format (doc.myDate,“DD.MMMM.YY”) or format (doc.myDate(“Munich, DD. of MMMM in YYYY”)
or
right(doc.name,5)
left(doc.name,4)
mid(doc.name,4,2)
Maybe anyone has some experience in doing that. Is there any documentation I havent found?
Thanks for your help!
Thilo