Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Currency in French Format

Naseem_S
Level 1
Level 1

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.

 

 

 

1 Reply
wodnicki
Community Advisor
Community Advisor

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