Converting Date in Formula Edit to Year-Month

[jotek]

I have a formula which converts a Date to Year-Month (2001-10) which I am using to Group records. The formula is: Year(Delivery_Date)&Month(Delivery_Date). The problem is that the answer comes back as 2,0000.000010.0000

The only thing I know of is the number "Options" on the report is set to -1,123.0000 since number fields on our reports need to be this format. I have tried to convert ToText and a few other things such as truncate but the result is always the same. I guess I don't want to change the other 8 numberic fields just becuase of one field not converting properly.
(using CR 8.5)

 

[IdoMillet]

Try something like:

Cstr(Year ({Delivery_Date}),0,'')&Cstr(Month({Delivery_Date}),0,'')

This would remove the decimal places and the
comma.

Cheers,
- Ido ixm7@psu.edu

 

[jotek]

You are very much appreciated. It worked like a charm!

 

[mustang8097]

There is an easier way. Set the group to the date field, and it will ask if you want to group by day, week, month, etc... The group name field will display accordingly.

HTH
LT