× 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
  • New Member
More
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 ,

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
3 years 6 months ago #22958 by VK
Replied by VK on topic Converting currency amount
Hi
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
  • New Member
More
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?

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
3 years 6 months ago #22963 by VK
Replied by VK on topic Converting currency amount
post here ENQUIRY setup for this field

Cheers
VK

Please Log in or Create an account to join the conversation.

  • silvergem
  • silvergem's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • TAFC|R12/R13, TAFJ|R20
More
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