How to use HistoricFieldValue in Javascript in a report?

[mkocur]

Hello,

I want to get an item's content of a specified date by using HistoricFieldValue.

The general definition of HistoricFieldValue is as follows: HistoricFieldValue(field-name, timestampconstant)

In my js script I'm trying to use it in this manner:

<%compute%>HistoricFieldValue("Content","March 21, 2017")<%endcompute%>

Normally it should work , but I think the problem is the date. What is a timestampconstant?

This Error message pops up

When i change it to

<%compute%>HistoricFieldValue("Content","Modified Date")<%endcompute%>

(This usage is senseless actually, but I want to describe the problem more precisely )

This error message occurs:

I hope somebody could help me how to use this HistoricFieldValue Function

Best regards

Martin

[MichaelChatel · Accepted solution]

Hi Martin,

You may want to open a Support case for assistance with this, but try the following format for timestamp-constant:

MMM d, YYYY HH:MM:SS [e.g. timestamp("Jul 25, 2014 6:18:36")]

[mkocur]

Hi Michael,

yes, this is it.

timestamp("Jul 25, 2014 01:00:00 PM")

THX for your help, i really appreciate it.

[mrump]

Hi Martin,

maybe you are interest in this approach as well

see plot any trend chart in report