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

Avatar

Avatar
Level 1
Naseem_S
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
Naseem_S
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
Naseem_S
Level 1

04-02-2021

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.

 

 

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

16-02-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