Filter a Date Range

[Katie Sikorski]

I want to Filter my production which is a 1/31/2011 format to be only dates greater than 12/31/15and I am not that familar with the expression yet. How do I need to enter P_Date > 12/31/15 I tried everything what is in there now is this.Thanks in advance.

[Neeraj Khatri]

What is the datatype of your date column If the column is string (varchar), then it needs to be convered to date field first.

Try using something like this:

 

The "Date()" function here converts the string to date format. Here is the description on how to use this function:

Creates a Date from a column or values. If a single argument is given, the input column can be of type String or DateTime. If a String is specified, the date must be written on a form that Spotfire can recognize and all parts of the date (year, month and day) must be present.

If three integer arguments are given, then the first argument is the year, the second is the month and the third is the date in that month.

Example:

Date([Column])

Date(2007, 05, 17)

[Katie Sikorski]

My Date Column in a Date Year/Month format I just want it to start on 1/2016 and ignore production prior to that.  Thanks,