count of last item of the day
- by frenchie
I have a query in which one of the fields contains the count of status. The status can change several times a day and the count should be based on the final status of the day. For instance, this is what I have for Status1.
CountStatus1 = (from status in MyDataContext.StatusHistories
where…