Error in FORMAT function after technical upgrade

einsTeIn.NET

Hi guys,

has anyone already noticed that in NAV 6 R2 the FORMAT function doesn't work correct? I mean, if you use parameter FormatNumber = 9 for a boolean then it should return XML format (true/false), but it gives you 0/1. This worked in former versions. And parameter Number = 9 of EVALUATE also still works for booleans.

Has anyone come across this issue and is there some kind of hotfix available? I didn't find one.:( If not, how did you solve this?

mohana_cse06

Its true..

Help file says

2009SP1
Boolean Format Example
<Text> 0 Yes/No
<Text> 1 Yes/No
<Number> 2 1/0
XML format 9 1/0

5.0 SP1
Boolean Format Example
<Text> 0 Yes/No
<Text> 1 Yes/No
<Number> 2 1/0
XML format 9 true/false

einsTeIn.NET

Interesting.... you're right.
But in 2009 R2 OnlineHelp says:

Boolean Format Example
<Text> 0 Yes/No
<Text> 1 Yes/No
<Number> 2 1/0
XML format 9 true/false

mohana_cse06

einsTeIn.NET wrote:

Interesting.... you're right.
But in 2009 R2 OnlineHelp says:

Boolean Format Example
<Text> 0 Yes/No
<Text> 1 Yes/No
<Number> 2 1/0
XML format 9 true/false

:bug:

einsTeIn.NET

Yeah, I also think that's a bug. But very interesting that it switched twice in OnlineHelp. That's very confusing especially if you consider that xml standard format did not change in the meantime.