Vb2008 crystal report

[gian363]

I'm working on a sales report, my date field is on MySql Format(yyyy-MM-dd)
I have this month in my formula fields

month({tbl_pos.date})

At the chart, the month displays 1.00, 2.00 which is equal to January and February, I need to know how to remove that decimal it's annoying

[rasinc]

Try

Format(month({tbl_pos.date}),'#')

or

Format(month({tbl_pos.date}),0)

I can't remember the exact syntax but it is searchable on the MS website.