How to sort the date in crystal report

[sommererdbeere]

hi,
i wanna sort the date in crystal report.. ihave done the group, but it still didn't work out.. here is my formula:
cstr(DatePart ("m",{DATE_ENTERED}),0)& "/" &
cstr({DATE_ENTERED}, "yyyy&quot

here i wanna only extract the month and year. i wanna sort according to year, however, the out put of the report looks like this: 1/2003
10/2003
12/2002
3/2003
4/2003

by how i can order them that looks like:
12/2002
1/2003
3/2003
4/2003
10/2003

many many thanks.
i thought this is pretty easy, but i found it not.. it will be great if someone can help in out. 'ocz i need to ahve this report goes out in an hour.. many many many thanks

sommer

 

[lbass]

Change the formula to:

cstr(DatePart ("m",{DATE_ENTERED}),"00&quot& "/" &
cstr({DATE_ENTERED}, "yyyy&quot

This will give you dates like: 02/2003

If you want to display the date like 2/2003, use your original formula for display, but use my suggested changed formula for the sort field.

-LB

 

[synapsevampire]

You don't need to create a formula for Grouping, select the date field for grouping and change the section will be printed to for each month.

The default display will be as you requested.

Or you can create formulas, which is less efficient.

-k

 

[Reebo99]

Use SV's solution, but just for the record, in future instead of using :

cstr(DatePart ("m",{DATE_ENTERED}),"00&quot& "/" &
cstr({DATE_ENTERED}, "yyyy&quot

Use :

ToText({DATE_ENTERED},"MM/yyyy&quot

Reebo
UK

 

[sommererdbeere]

thanks for all those who help.. thank u..