database stuff

[pinbrook]

I want to create a report based on order date (ie the day the order was placed) I can't seem to find this date

The only useable field seems to be in the payment history table TimeDateCreated

Is there a date anywhere else?

[HowardW]

Hi Jo
try the order table which as got the date ordered, date received and date finished.
Regards
Howard

[Jan]

You can use your free mailing list license with my batch order processing tool to get a report in 'date recieved' order. Just select by date and tick the box to print a summary report before processing.

Regards,

[pinbrook]

I need a custom report to filter orders by date, product reference number and a custom var....

But i am looking at the batch processing moles. This is the job we have discussed but the goal posts keep moving so I can't commission reports yet!!

[Jan]

I though that you did crystal reports consultancy at Pinbrook?

Cheers,

[pinbrook]

No.... we gave it up when you started up!! :)


In reality we decided to withdraw the service - something to do with "Jack of all Trades" master of none. It was a very small part of the business, we still do abit for exsisting clients, but don't advertise it.


We'd rather send the work to you!!

[Jan]

:-) Thanks Jo