Hi Jonathan,

Is endDate defined as a string or DateTime type on your content model?

I'm sure there are ways to compare the string but as far as I understand if it's set as a DateTime i.e. on your documentType then you should be able to do the following:

// check whether you have a date OR if its set to the min date value - if true we want to add it    
x => x.Value<DateTime>("EndDate") == null || x => x.Value<DateTime>("EndDate") == DateTime.MinValue

// check whether your end date is set in the future or equals the current day - if true we want to add it
x => x.Value<DateTime>("EndDate")  >= DateTimeNow

I'm on the train so my syntax may be a little off but with the two together maybe try

items = items
        .Where((x => x.Value<DateTime>("EndDate") == null || x => x.Value<DateTime>("EndDate") == DateTime.MinValue) 
                 || x => x.Value<DateTime>("EndDate") >= DateTime.Now ))

Basically, if the first check equates to false the right check is still evaluated. if either the left or right check evaluates to TRUE then its added to items.

Maybe it might be worth splitting it up using if statements first and then condense using LINQ. Get it working then refactor.

When you are outputting the date value in the view you can call ToString() to format it, loop through the items and call

item.Value<DateTime>("EndDate").ToString("yyyy-MM-dd")

I hope this helps in some way.

is working on a reply...