title: Tibco Spotfire, how to insert yesterday column based on current date
body: <p>Tibco Spotfire, how to insert yesterday column based on current date.</p>
  
  <p>how to insert calculated column for an yesterday based on current date time.</p>
  
  <p>i.e: </p>
  
  <pre><code>if current date: 08/09/2016 (dd/mm/yyyy)
   ---------------------
   | price | yesterday |
   ---------------------
   |  100  | 07/09/2016|
   |  150  | 07/09/2016|
   ---------------------
  </code></pre>