Question:
Why is a filter by date, recorded as a string, not working?
Solution:
For the comparison logic to work (value higher than InitialDate, but lower than FinalDate), the value must be DateTime. If it were recorded as a string, for example, the query would not be able to apply this kind of logic.
If date/time information is a string, you can runVBScript’s CDate() function, which converts the string to DateTime. Then, you will be able to record the correct type of information so that your filter can work properly.
