displaying max(date) as non-selectable text

[Anonymous]

Hi,

I want to display in the app how current the data mart data is using the maximum activity_date value.

I can do this in a statistics box, but then the value is selectable and I do not want users to filter data by clicking on that.

So I created a text box with the following, BUT the month portion is displaying as 00.

(If I change the mm/dd to dd/mm then the 00 displays where te mm is moved to.)

= timestamp(max(ACTIVITY_DATE),'mm/dd/yyyy hh:mm')

What is the best way to do this computation and display it as read-only/not selectable?

Thanks!

[jagannalla]

=Max(Date(ACTIVITY_DATE,'MM/DD/YYYY hh:mm:ss'))

try this..

if you don't want to filter the ACTIVITY_DATE based on the other selections remove the relationship with this field during loading itself.

[Anonymous]

Actually, I do want a relationship with Activity Date, but only through a selection on it via a multibox.

Ideally, I'd like to use the Stats box and make that object read-only, but I don't see a way to

do that.  I've used text boxes to display other things (a count of course section, a sum of the number os activities) and this has worked fine.  But it is puzzling that the month portion of the date is somehow lost when I use the max function on the text object.  I get 00/06/2011  when it should be 06/06/2011.  If there were any sort of truncating going on, I would have expected it to be on the day number rather than the month number...

[swuehl · Accepted solution]

Have you used the format code as given by Jagan N?

It is important to use 'MM' for month, since 'mm' is representing minutes. Are your minutes '00' also?

[Anonymous]

Yes there is case sensitivity in the formatting, an the minutes were 00 which is why the lowercase mm returned the wrong value.  Thanks so much!