SQL Table Date to Date

Ignition
1

I created a table to showcase some values and would like to filter out data based on two Drop down menu’s which will allow user to see data from a given day to another given day. The drop down menu’s have 1-31 for days. Here is my SQL Query

SELECT Flow, Level, t_stamp FROM testing WHERE t_stamp BETWEEN “'2018-6-” + {Root Container.Dropdown 1.selectedValue} + " 00:00:00’" AND “'2018-6-” + {Root Container.Dropdown 3.selectedValue} + " 23:59:00’"

and

SELECT Flow, Level, t_stamp FROM testing WHERE t_stamp BETWEEN “'2018-6-” + ‘{Root Container.Dropdown 1.selectedValue}’ + " 00:00:00’" AND “'2018-6-” + ‘{Root Container.Dropdown 3.selectedValue}’ + " 23:59:00’"

This does nothing, but if I take out the dropdown menu’s like this:
SELECT Flow, Level, t_stamp FROM testing WHERE t_stamp BETWEEN ‘2018-6-12 00:00:00’ AND ‘2018-6-12 23:59:00’

it works

Any thoughts?

2

Just use single quotes. Here’s an example I just tested:

SELECT top 10 *
FROM AUDIT_EVENTS
WHERE EVENT_TIMESTAMP > '2018-6-' + '{Root Container.Dropdown.selectedValue}' + ' 00:00:00'
3

did the between function work for you, using single quotes with the between function doesnt seem to work with me.

4

Yes, just changed my example to BETWEEN and it worked as expected.

5

is there a better way of looking at data between two different dates? I cannot seem to get thsi query to filter out corrrectly.

6

Yes, using Calendar controls.

Post your updated code. It's gotta be close.

7

SELECT Flow, Level, t_stamp
FROM testing
WHERE t_stamp
BETWEEN ‘2018-6-’+’{Root Container.Dropdown 1.selectedValue}’+’ 12:00:00’ AND ‘2018-6-12 14:59:00’

8

What is the value and type of Root Container.Dropdown 1.selectedValue? Are you receiving any sort of error?

9

Values are 1-16. No no errors. I am currently trying the calenders and having more success. Code looks correct though, yeah?

10

What if you try using the .selectedStringValue property of the dropdown? I suspect there is some problem with integers and strings be combined.