×
Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...
Converting currency amount
- donquixote
- Topic Author
- Offline
- New Member
Less
More
- Posts: 9
- Thank you received: 0
3 years 6 months ago #22955
by donquixote
Converting currency amount was created by donquixote
How would I convert an amount of 1124.34 to 1124,34
So a . to a ,
So a . to a ,
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
Less
More
- Posts: 1106
- Thank you received: 148
3 years 6 months ago #22958
by VK
Cheers
VK
Replied by VK on topic Converting currency amount
Hi
where?
in jBC:
in enquiry: see help for CONVERSION field.
where?
in jBC:
CHANGE '.' TO ',' IN the_amount
in enquiry: see help for CONVERSION field.
Cheers
VK
Please Log in or Create an account to join the conversation.
- donquixote
- Topic Author
- Offline
- New Member
Less
More
- Posts: 9
- Thank you received: 0
3 years 6 months ago #22960
by donquixote
Replied by donquixote on topic Converting currency amount
I have tried the convert in the enquiry using CONVERSION field but I think because it is currency rather than a string it won't let me use SUBSTITUTE ,,.
Any suggestions on using the CONVERSION field?
Any suggestions on using the CONVERSION field?
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
Less
More
- Posts: 1106
- Thank you received: 148
- silvergem
- Offline
- Elite Member
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 246
- Thank you received: 19
3 years 6 months ago - 3 years 6 months ago #22966
by silvergem
Replied by silvergem on topic Converting currency amount
On Enquiry CONVERSION field, you can use CONVERT X,Y (CONVERT .,,) or you can use LENGTH.MASK field
Last edit: 3 years 6 months ago by silvergem.
Please Log in or Create an account to join the conversation.
Time to create page: 0.162 seconds