Date not sorting in right order

Moderators: Moderators, Tech Support

Post Reply
cthomas
Posts: 17
Joined: Fri Jun 19, 2009 11:01 am

Date not sorting in right order

Post by cthomas »

I'm doing a custom report that will show me me the members that have join dates entered and it is sorting all of January together, February together, etc. I need it to sort by year, month, then day. Can anyone tell me what needs to be done?

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Date not sorting in right order

Post by Zorak »

Is it grouping all of January together, regardless of the year?

That sounds odd.

What is it that you currently have set up in the report, regarding the sort or grouping?

cthomas
Posts: 17
Joined: Fri Jun 19, 2009 11:01 am

Re: Date not sorting in right order

Post by cthomas »

Yes it's grouping all my January together, etc. regardless of the year. I need it to sort by year, month, day.
My sort is Join Date.
My filter is Join Date is not missing a date.
When the join date is entered on the member profile it is enter mm/dd/yyyy.

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Date not sorting in right order

Post by Zorak »

Is your 'Joined Date' field in the profile notes, instead of the date fields?

I just verified on this end that sorting by a date field will indeed sort properly in YYYY,MM,DD order.

If you have one of the customizable notes fields labeled Join Date, then it will be sorted like a text field 01/01/2009, 01/02/1960, 01/03/2002, etc.

cthomas
Posts: 17
Joined: Fri Jun 19, 2009 11:01 am

Re: Date not sorting in right order

Post by cthomas »

My join date is under maintain personal profiles, Dates & Codes Tab, in the 4th Date Field above User Codes. There is even a drop down arrow that lets me select a date from a calendar.

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Date not sorting in right order

Post by Zorak »

That is so odd.

Do you have any groups set on the output fields? That is the only other thing that I can think of that would cause the sort order to change.

cthomas
Posts: 17
Joined: Fri Jun 19, 2009 11:01 am

Re: Date not sorting in right order

Post by cthomas »

I don't believe so. I didn't select any. I've opened each field in the 'select fields to show in query' and selected 'remove this fields designation'.

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Date not sorting in right order

Post by Zorak »

We will follow up through e-mail on this.

Post Reply