Date not sorting in right order
Moderators: Moderators, Tech Support
Date not sorting in right order
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?
-
- Tech Support
- Posts: 3006
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Date not sorting in right order
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?
That sounds odd.
What is it that you currently have set up in the report, regarding the sort or grouping?
Re: Date not sorting in right order
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.
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.
-
- Tech Support
- Posts: 3006
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Date not sorting in right order
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.
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.
Re: Date not sorting in right order
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.
-
- Tech Support
- Posts: 3006
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Date not sorting in right order
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.
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.
Re: Date not sorting in right order
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'.
-
- Tech Support
- Posts: 3006
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Date not sorting in right order
We will follow up through e-mail on this.