Search code examples
datetimespotfire

Tibco Spotfire, how to insert yesterday column based on current date

Tibco Spotfire, how to insert yesterday column based on current date.

how to insert calculated column for an yesterday based on current date time.

i.e: 

if current date: 08/09/2016 (dd/mm/yyyy)
 ---------------------
 | price | yesterday |
 ---------------------
 |  100  | 07/09/2016|
 |  150  | 07/09/2016|
 ---------------------
Solution

  • You can use DATEADD('dd',-1,DATE(DATETIMENOW())). If you remove the DATE() part it will include the time as well.