Limiting data using expression - with a date

A quick tip on using a date to limit data in a visualization with a date.  I found this non-intuitive and undocumented.

This syntax for the boolean expression using a date works:

[SnapshotDt]=Date('5/24/2013')

Interestingly, Date() is not a documented function in the expression builder.

You may also wish to create a document property for your date rather than hard coding a single date.

I created a document property called ViewDate.

To filter data in my visualization to the value of this property, I used the boolean expression

[SnapshotDt]=Date('${ViewDate}')

[SnapshotDt]=${ViewDate} does not work!

PS - I am on version 4.0.

Attachments

AttachmentSize
Image icon limitDataUsingExpression.png39.49 KB

(5) Answers

Login