Allow date-time data types to work with filter operators
Description
In Customer Journey Analytics, dimensions can be configured to use a date-time schema data type. For example, a dimension showing when a product was added to wishlist could use this data type. Despite dates being akin to numbers, they cannot be used with greater than and less than operators in fitlers. The recommendation is to allow for this type of functionality.
Why is this feature important to you
Allowing the use of operators on dimensions that use a date-time data type would be useful for filter creation.
For example, let's say that a user wanted to see a list of customer IDs that added a product to a wishlist between September 20, 2023, and October 20, 2023. A dimension exists that captures the date that a product was added to a wishlist (Dimension 1), and the dimension's values are in date-time format. If filter operators worked with date-time dimensions, the user could build a filter with logic similar to "greater than or equal to Dimension 1 = Sep 20, 2023, and less than or equal to Dimension 1 = Oct 20, 2023". Currently, the user would have to list out 31 different dimension values to cover each of the dates from Sep 20, 2023, and Oct 20, 2023.
How would you like the feature to work
Treat dimension values with a date-time data type as numbers, which will allow greater than, less than, etc. operators to be used.
Current Behaviour
Dimensions with date-time data types do not currently work with operators.