Year([Arrival Date]) Produces 2,015

[PWD]

Good afternoon, as you can see from the title I'm attempting to extract just the year from an Arrival date and it is formatting it as a number, including the 000's separator.

I have worked around this with

Right(FormatDate([Arrival Date];"dd/MM/yyyy");4)

but I just wondered if this was absolutely necessary or if there was another way of doing this.

Many thanks,
D€$

 

[SkipVought]

Well, Left(), Right(), Mid() are string functions, but I'm not familiar with the conversions that BO does in formulas, but clearly BO is converting "2015" to 2015.

Why not Year([Arrival Date]) ???

Either way it's just formatting, so what's the problem?

 

[PWD]

Hi Skip, yeah that's what I started with but it produces "2,015". At least I have a solution. I just BO rather frustrating.

Many thanks,
D€$

 

[SkipVought]

Are you saying that it results in TEXT "2,015" and not just a formatted number?

 

[hilfy]

The Year() formula results in a number, which Webi is applying its default number formatting to, adding the comma. You should be able to select the variable object on the report and format the number so that it doesn't include the comma in the format.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com