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

Question

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.

SELECT * FROM [CData].[MYOB].[SaleInvoices] where Date>DATEADD('d', -1, CURRENT_DATE())

But this returns all the invoices after this date. (as no end date specified) I need to limit this to an end date.

Has anybody got any ideas?

Tag your question with the database you are using. – Gordon Linoff May 17 '21 at 20:35 — Gordon Linoff, May 17 '21 at 20:35

score 0 · Accepted Answer · answered May 17 '21 at 19:43

0

Have you tried the BETWEEN operator?

SELECT  *
FROM    CData.MYOB.SaleInvoices
WHERE   Date BETWEEN DATEADD('d', -1, CURRENT_DATE()) AND CURRENT_DATE()

answered May 17 '21 at 19:43

Mike Petri

570
3
10

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

1 Answers1