Metric Refresh date is not coming in date format.

other Performance Management
1

Hi,

I applied rules on a metric that, whenever the metric refreshes, based on the metric value, BO should send a mail.

I added a mail alert as an action item in Rules.
In the mail text message I used the formula - metric1.lastrefreshdate.

But the value displays as follows.
Last Refresh Date: 14272.65

Can you please let me know, how to display the value in date format.?
I tried using the fucntion TextDate(metric1.lastrefreshdate). But it returned “Error evaluating action expression. #v1.LASTREFRESHDATE)”

GowthamSen :india: (BOB member since 2006-08-31)

2

Hi,

Now I am able to display date in proper format.
I used the following fuction.

Last Refresh Date is #f TextDate(metric1.lastrefreshdate) %

GowthamSen :india: (BOB member since 2006-08-31)