How putting the actual date inside Spotfire report pages

[Pasquale Massimo Scorca]

Hi,

in a my Spotfire report I need to put and show the actual date for each page.

Any suggests to me, please?

Many thanks

[Kevin Flynn]

What do you mean by the actual Date for each Page? Do you mean the Last time the data was loaded? or just the Current Date?

I currently use the below 3 ways with different dashboards:

1. Current Date: DateTimeNow()
2. Most Recent Date from the data: Max([DateField])
3. Create a new column in the Transformations section. Create it as DateTimeNow() (this will put the last time the data was loaded)

[Pasquale Massimo Scorca]

Hi Kevin, thanks for your reply.

I think to use the current date as a report date.

Where do you specify the DateTimeNow() function? As a document property or a calculated column? Put it in a text area? In which object?

Thanks

[Kevin Flynn]

You can either use it in a Calculated Column, or if you just want to display the current date time then you would put it as a Calculated Value in a Text Area.

[Tejas Devadkar]

To add to Kevin's, As far as my experience , on the Web Player the DateTimeNow() will pick up the date of the Node manager Server machine and not the Client Machine (i.e on which the report is consumed/viewed) . Since all the reports viewed on the WP are executed via Node manager.

you could also review the below article

https://support.tibco.com/s/article/How-to-display-System-Date-in-Spotfire