When comparing string to date there isnt thrown any error but I dont get all the data

[Mary456]

I have created a string custom field. In this fields I store the system date for example :2019-08-01 19:28:17

When trying to compare this field with  a date Alteryx doesn't throw any error but I only get 110 records out of 500 . In the Where criteria I have executed the following statement.

where Custom_Field Between Date '2012-01-01' and Date '2014-01-01'

Does anyone have any idea how the comparison works in this case.

[Emmanuel_G]

@Mary456 

Is it possible to have a workflow or any screenshoot of workflow and values which disappear for more details ?

[Mary456]

In the workflow I have specified only Input data and browse. It is a very simple workflow. 

In the results I get only first 110 record even though the other records are between the interval that I have specified in the query. I'm not sure why this happens. 

The query that I'm executing in SQL editor is:

Select * From Table_Name where Custom_Field Between Date '2012-01-01' and Date '2014-01-01'

[Mary456]

In the workflow I have specified only Input data and browse. It is a very simple workflow. 

In the results I get only first 110 record even though the other records are between the interval that I have specified in the query. I'm not sure why this happens. 

The query that I'm executing in SQL editor is:

Select * From Table_Name where Custom_Field Between Date '2012-01-01' and Date '2014-01-01'