How to filter visualization using a date range from user input using property control

[Jason Elkin]

I'm attempting to limit the data displayed by a visualization by comparing a date range set by the user with a property control. The date range is compared to the dttmspud column and is supposed to show "True" if the date is within the input range, and "False" if the datedoes not fall within the date range. The visualization would then be limited to only the data with a "True" result using the "limit data using expression"in column properties.

I created two property controls that allow the user to pick a date which are identified by the "BeginDate" and "EndDate". The available dates are unique values from the dttmspud column which are the dates being compared to the date range chosen by the user. These dates are queried and are input in another program.

An example value for the BeginDate and EndDate can be seen in the attached image in available properties for column. I've tried using the Date and DateTime function to make sure formatting is correct but doesn't help.Depending on the operator used, I get either all False or all True results.

[Jason Elkin]

Not sure why, butadding quotes to the property control dates being compared to the dttmspud date appears to fix the issue. The If statement looks as follows, if thequotations are removed it does not read the dates correctly

If([DateTime([dttmspud]])] >= DateTime("${BeginDate}")

And[DateTime([dttmspud]])]

[Shashank Gurnalkar]

When the document property type is not Integer/Real, you need to put it in the quotes when you are inserting it as a text. Instead, you can also insert it as value like: DocumentProperty("BeginDate")

Apart from that, you can also avoid using the IF() loop because the expression itself is a boolean.

([DateTime([dttmspud]])] >= DateTime("${BeginDate}") And [DateTime([dttmspud]])]

[Jason Elkin]

Thank you for the help.