Date Range of 'Last Month' in Order Manager bug?

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
sroby
Ensign (ENS)
Ensign (ENS)
Posts: 3
Joined: Tue Dec 16, 2008 10:46 am

Date Range of 'Last Month' in Order Manager bug?

Post by sroby » Mon Nov 02, 2009 12:50 pm

In Order Manager, choose All or All valid under Order Status and choose Date Range of 'Last Month'....for us we don't see orders for 10/31/2009. If we choose last 30 days or Last Week...we see those orders. Has anyone else seen this issue? Bug? Running 7.0.3. Build: 12458

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Date Range of 'Last Month' in Order Manager bug?

Post by mazhar » Tue Nov 03, 2009 5:51 am

Its a wild guess it may be because of time part in data taking part in filtering criteria. Give a try and edit Admin/Orders/Default.ascx.cs file and locate following code

Code: Select all

criteria.OrderDateEnd = AlwaysConvert.ToDateTime(HiddenEndDate.Value, DateTime.MaxValue);
and replace it with these lines

Code: Select all

criteria.OrderDateEnd = AlwaysConvert.ToDateTime(HiddenEndDate.Value, DateTime.MaxValue);
criteria.OrderDateEnd = new DateTime(criteria.OrderDateEnd.Year, criteria.OrderDateEnd.Month, criteria.OrderDateEnd.Day, 23, 59, 59);
Save the file and again try the date filter having problem.

sroby
Ensign (ENS)
Ensign (ENS)
Posts: 3
Joined: Tue Dec 16, 2008 10:46 am

Re: Date Range of 'Last Month' in Order Manager bug?

Post by sroby » Mon Nov 09, 2009 8:29 am

That did it. Thanks Mazhar!

Post Reply