You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

64
Views
1
Comments
edited Mar 28, 2023 4:10AM in Configure Price Quote 1 comment

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 -

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!