You are viewing limited content. For full access, please sign in.

Question

Question

Query a SQL table with a date range

Workflow

Updated August 27, 2020

asked on August 26, 2020

Has anyone created a query in workflow where you need the information pulled back based on a date range?

0 0

Replies

replied on August 27, 2020

You will need to do a custom Query which selects between 2 dates, i have attached an example in the link.

SELECT * FROM Orders
WHERE OrderDate BETWEEN #01/07/1996# AND #31/07/1996#;

https://www.w3schools.com/sql/sql_between.asp

3 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked August 26, 2020
Updated August 27, 2020
124 views