Hello,
I have searched the forums and Domino Designer help, but I can’t figure out how to do this. In my view in the first column, I have the formula @Text(@Created). What I am wanting is for the lastest dates to display at the top of course since these are news items we are adding to our website. What I am getting is the highest month date displaying first (12/01/2002 for example) and not 4/25/2005 or whatever the lastest date is. How can I fix this to get it the way I want? I have tried playing araound with the column settings, but can’t come up with anything that works for me.
any assistance is greatly appreciated.
-Bruce
Subject: view column - displaying most recent date at the top
What I’ve done is break up the date into 3 columns that you hide and sort with. So start with @Year(@Created), and then @Month(@Created) and @Day(@Created), then sort each one descending and then hide all 3 columns, and then the @Text(@Created) will be there for display to the user.
Post again if this didn’t quite make sense or you need more help.
Subject: view column - displaying most recent date at the top
Don’t use @Text if you want to sort in date order. If you need to use @Text in order to add other info in the same column, then make that column unsorted and use @Created all by itself in a separate, sorted column and hide the column.
Subject: RE: view column - displaying most recent date at the top
Thanks for the replys…
well, the @created sounds easy enough, but when I take out @text, nothing shows
up. I have it surrounded by html. For instance, in the formula field, what I
currently have is “span class=‘columntext’>” + @Text(@Created) + “]”
and if I take out @text, nothing shows in that column.
Subject: Then Create a Hidden Sorted Column before your display column that just has the @Created Formula.
Modify your current column to Not sort.
Subject: RE: Then Create a Hidden Sorted Column before your display column that just has the @Created Formula.
no matter what I do, whenever I take out @text, nothing shows up in my column.
so I had “span class=‘columntext’>” +@Text(@Created) + “]”
I create my first column to sort ascending and make it hidden then for my
second column I have in the formula display
“span class=‘columntext’>” (@Created) + “]”
see anything I am doing wrong?
Subject: First, your hidden column w/ @Created should sort Descending and the second visible
column should have “span class=‘columntext’>” + @Text(@Created) + “]”
Subject: RE: Then Create a Hidden Sorted Column before your display column that just has the @Created Formula.
The sorted column should have nothing but @Created in it. You can’t add any text, since you can’t directly concatenate text and date/time values.
Subject: Just make the formula @Created. Forget the Text. Sort in Descending order.