Greater Than a Date Range In A Custom Expression

[Katie Sikorski]

I have tried everything the only way I can get greater than is with a filter. Is there away to say Date > 12/31/2015 in an expression I can't seem to get anything to work.

[Fabian Duerr]

Have you tried to parse your date using the ParseDate() function or using Date()

 

For example:

 

[your.column] < Date(2015,12,31)

 

You cannot compare a regular string object with a date object. You need to convert it first.

[Katie Sikorski]

I put this in.  [P_DATE]>Date(2015,12,31)  and I got a Chart with False on one end and true on the other but no production line or production bar chart see example of what I am getting and what I need thanks.

[Katie Sikorski]

Attached examples

[Fabian Duerr]

Please go to the properties of your visualization -> data -> limiting data using expression -> edit and put the expression there. Don't put it on x-axis. Leave this axis on P_DATE

 

This will act like a hard-coded filter to the data just in this visualization.