Tip Tuesday - Query from a Data Table based on a column that stores Date values

Date comparisons in Data Table queries can be difficult as there are no Date Type columns supported in Data Tables and you are required to store date values in string columns. When these date values are used directly in where conditions with greater than ,less than comparisons , they do not provide expected results always because of the data type and format mismatch; you need to perform additional steps to convert these string values to Date type with desired date format before you can use them in where clauses and menu filters.

As a workaround you can store the Dates in Data Table columns in the format -