Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • gary 385 posts 916 karma points
    Feb 26, 2013 @ 19:34
    gary
    0

    V6 GroupBy and DateTime Format

    Hi, need some help finishing this off, if possible.

    This is what I have, it groups under a date then by create date, both descending. This part is fine and returns as required.

    @{   var root = Model.Content.AncestorOrSelf();

       var top = root.Descendants("dailyspecials").OrderBy("Date desc").GroupBy("Date");

        }

        @foreach (var groupDate in top)  

        { @groupDate.Key

            foreach (var item in groupDate.OrderBy("CreateDate desc"))
            {
             <ul>
                 <li><a href="@item.Url()">@item.Up(1).GetPropertyValue("Restaurant")</a></li>
                 <li>@item.GetPropertyValue("Date"))</li>
             </ul>   
               }
            }
    The part that I am struggling to achieve is to convert the Object Date, into a string to give something "readable" that can be displayed. At the moment it returns 3/23/2013 12:00:00 AM. To achieve the GroupBy, I have had to use the static, but, would either would like to achieve dynamically, or convert the returned object, Date to a DateTime string. Have tried dynamically but coudn't use GroupBy, so from the static, I can use either the Key, or the property Date. Tried to convert it in C# but it would appear that the Umbraco Long date is a different form to MVC Long date.
    It seems like the hard part was done but have been stuck on this for a day - if anyone could add something to achieve a date time format from what I have or achieve another way, it would be very much appreciated.
    Best regards G

    Copy Link
  • p.kidd 15 posts 55 karma points
    May 16, 2013 @ 23:59
    p.kidd
    0

    Did you get anywhere with the date formatting?

    Copy Link
  • gary 385 posts 916 karma points
    May 17, 2013 @ 00:15
    gary
    0

    hi

    i did get this working, so the answer is yes.

    however i am writing this on my phone as a combination of sql server and webmatrix 3 killwd my machine stone dead.

    i may be able to get he answer via the phone, but before i go looking, was it a group by as above using key that you need, or is it.just a striaght date format?

    Sorry to ask to be specific, but am a bit.limited but will help all i can

    regards

    g

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies