When I use the Advance Search function, namely date, I use the between function. This gives me two dates to choose from.
this works well however, my problem is the following:
Date field is structured as DATETIME
So to get todays sales I need to select todays date (start) and then tomorrows date (end). This will then show all sales from midnight to midnight.
Is there a way to have the calendar say select sunday as the end date but sumbit monday (+1 day) into the query.
I hope this makes some sense.
wayne