Announcement

Collapse
No announcement yet.

database stuff

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    database stuff

    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?

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

    Comment


      #3
      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,
      Jan Strassen, Mole End

      Comment


        #4
        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!!

        Comment


          #5
          I though that you did crystal reports consultancy at Pinbrook?

          Cheers,
          Jan Strassen, Mole End

          Comment


            #6
            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!!

            Comment


              #7
              :-) Thanks Jo
              Jan Strassen, Mole End

              Comment

              Working...
              X