Hi,
I have encountered a problem and hope someone can help me.
I want to add a criteria to a date property (drop down function) that compares the month and year. Tried ([feature_instance_alias:property_name] >= minValue) && ([feature_instance_alias:property_name] <= maxValue), but not getting the results I want.
Thanks
Hi Erika,
We are working on this issue with you through service request 7000730209. Please check the suggestions provided there and update us.
-Komal S.
Notes:
When comparing dates which store their values as dateticks, you will need to compare to the dateticks value. Ex. [MYDATE] < 635266927640000000…where 635266927640000000 is the ticks value for 30-Jan-2014 We got this ticks value by setting MYDATE property value to 30-Jan-2014 using the Edit Properties tool. Then used Analyze with “Tree” mode to see the raw ticks value for 30-Jan-2014. Also see the attached example.DateCriteria.xml
It may try to truncate the values hence have suggested to use [Survey_Date].0 > 636515347190000000.0 && [Survey_Date].0 <= 636542131190000000.0By forcing the C expression evaluator to see the numbers as floating point.