Search code examples
spotfiretibcospotfire-analyst

What is the formula for date range in spotfire?


I would like to filter my data in spotfire using a date range formula, like this Date > '2020-05-01'

May i know how to write this date rangr using spotfire formula?


Solution

  • The correct syntax would be : [ColumnName] > Date('2020-05-01) This will take your string of '2020-05-01' and convert it to a date which can be used to compare to your date column. This can be used in data limiting expressions in a visual , calculated column or anywhere else an expression can be used.