Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
=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.
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...
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?
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!