No Count with DateTime<='2017-7-22 23:59' and DateTime>='
Posted: Sat Jul 22, 2017 11:41 am
Question.
I added DateTime <= '2017-7-22 23:59' and DateTime >= '2017-6-10 00:00' to the working query below but after adding this part the query delivers a 0 record count and it should be 4.
Working query which counts records (4): SELECT COUNT('L0_NodeLabel') as 'L0_NodeLabel' FROM 'Registrations' WHERE IssueType LIKE '%' AND Status LIKE '%' AND L0_NodeLabel = 'Root 1' AND IssueYN LIKE '%'
After adding the DateTime Column part:
Not working as expected query which countt 0 records (0) but should count 4: SELECT COUNT('L0_NodeLabel') as 'L0_NodeLabel' FROM 'Registrations' WHERE DateTime <= '2017-7-22 23:59' AND IssueType LIKE '%' AND Status LIKE '%' AND DateTime >= '2017-6-10 00:00' AND L0_NodeLabel = 'Root 1' AND IssueYN LIKE '%'
The DateTime Column is a TEXT type Column.
Can someone enlighten me in why the DateTime filter does not work?
Regards,
Paul
I added DateTime <= '2017-7-22 23:59' and DateTime >= '2017-6-10 00:00' to the working query below but after adding this part the query delivers a 0 record count and it should be 4.
Working query which counts records (4): SELECT COUNT('L0_NodeLabel') as 'L0_NodeLabel' FROM 'Registrations' WHERE IssueType LIKE '%' AND Status LIKE '%' AND L0_NodeLabel = 'Root 1' AND IssueYN LIKE '%'
After adding the DateTime Column part:
Not working as expected query which countt 0 records (0) but should count 4: SELECT COUNT('L0_NodeLabel') as 'L0_NodeLabel' FROM 'Registrations' WHERE DateTime <= '2017-7-22 23:59' AND IssueType LIKE '%' AND Status LIKE '%' AND DateTime >= '2017-6-10 00:00' AND L0_NodeLabel = 'Root 1' AND IssueYN LIKE '%'
The DateTime Column is a TEXT type Column.
Can someone enlighten me in why the DateTime filter does not work?
Regards,
Paul