Currency in French Format | Community
Skip to main content
N
Naseem_S
February 4, 2021
Question

Currency in French Format

  • February 4, 2021
  • 1 reply
  • 1182 views

Hi, 

 

I am trying to covert a numeric field into Currency in French Format . 

I tried using FormatCurrency(<Amount>,<Currency>), but it throws an error:

ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot find either column "MA_UAT" or the user-defined function or aggregate "MA_UAT.FormatCurrency", or the name is ambiguous. SQLState: 37000

 

Is there a way to achieve this through a function or a code?

Thanks.

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity Advisor
Community Advisor
February 16, 2021

Hi,

 

It's missing in my postgres db; funcList.xml only shows a definition for SQL Server, which you have.

Check db if it's available?

 

Thanks,

-Jon

Terms & ConditionsAccessibility statement

Loading footer...