Tag: myob

Using SQL code, i need to create a string that automatically creates the dates between to seperate days

I am creating an automatically updating dashboard for repeating purposes and I need to automatically draw invoice values from our system between certain dates i.e. on Tuesday, the reporting needs to show Mondays invoices. Is it possible to create a string whereby dates are automatically set. So far I have realized that DateAdd exists 🙂 I have created this. But

SQl query across 2 tables with conditional

myob sql

Using the MYOB database I want to query across two tables. I have the following inner join occuring and it’s linked between the ShippingMethodID. INNER JOIN ShippingMethods ON Sales….