How to modify a date for an order in NAVICAT(table salesorder)
If a date needs to be modified for an invoice, go to Navicat and look for the table called "salesorder" or just enter: SELECT * from salesorder;
As the displayed list might be overwhelmingly long, you might then need to type: SELECT*from salesorder WHERE ID=12700:
This way, your query will return only the searched row that needs the update.