C# - Return record which has the lowest PayDate but also the highest ReconciliationDate [duplicate]












0
















This question already has an answer here:




  • LINQ OrderBy with more than one field

    6 answers




So I need to pull the record which matches the following criteria:



A record which has the lowest PayDate but also the highest ReconciliationDate.
An example of records can be seen like this



public class Data {

    public string Name { get; set; }

    public DateTime PayDate { get; set; }

    public DateTime ReconciliationDate { get; set; }

}



--------------------------------------------------

| Name   | PayDate    | ReconciliationDate       |

--------------------------------------------------

| Andrew | 11/14/2018 | 07/01/2018               |

--------------------------------------------------

| Andrew | 10/14/2018 | 06/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 08/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 03/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 10/01/2018               |


So the correct record to be returned would be #5



How can I achieve this using C#?



I have this so far:



    var recordsNextCouponPaymentAfterLastOfMonth = externalInterestForSecurity.Where(aExternalRecord => aExternalRecord.PayDate > priorMonthEnd);





c# linq







share|improve this question













marked as duplicate by Camilo Terevinto c#
Users with the  c# badge can single-handedly close c# questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 14 '18 at 22:40


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.



















  • You could sort the list with OrderBy, OrderByDescending, ThenBy, and/or ThenByDescending, then take the first row. See this question.

    – John Wu
    Nov 14 '18 at 22:38


















0
















This question already has an answer here:




  • LINQ OrderBy with more than one field

    6 answers




So I need to pull the record which matches the following criteria:



A record which has the lowest PayDate but also the highest ReconciliationDate.
An example of records can be seen like this



public class Data {

    public string Name { get; set; }

    public DateTime PayDate { get; set; }

    public DateTime ReconciliationDate { get; set; }

}



--------------------------------------------------

| Name   | PayDate    | ReconciliationDate       |

--------------------------------------------------

| Andrew | 11/14/2018 | 07/01/2018               |

--------------------------------------------------

| Andrew | 10/14/2018 | 06/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 08/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 03/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 10/01/2018               |


So the correct record to be returned would be #5



How can I achieve this using C#?



I have this so far:



    var recordsNextCouponPaymentAfterLastOfMonth = externalInterestForSecurity.Where(aExternalRecord => aExternalRecord.PayDate > priorMonthEnd);





c# linq







share|improve this question













marked as duplicate by Camilo Terevinto c#
Users with the  c# badge can single-handedly close c# questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 14 '18 at 22:40


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.



















  • You could sort the list with OrderBy, OrderByDescending, ThenBy, and/or ThenByDescending, then take the first row. See this question.

    – John Wu
    Nov 14 '18 at 22:38
















0












0








0









This question already has an answer here:




  • LINQ OrderBy with more than one field

    6 answers




So I need to pull the record which matches the following criteria:



A record which has the lowest PayDate but also the highest ReconciliationDate.
An example of records can be seen like this



public class Data {

    public string Name { get; set; }

    public DateTime PayDate { get; set; }

    public DateTime ReconciliationDate { get; set; }

}



--------------------------------------------------

| Name   | PayDate    | ReconciliationDate       |

--------------------------------------------------

| Andrew | 11/14/2018 | 07/01/2018               |

--------------------------------------------------

| Andrew | 10/14/2018 | 06/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 08/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 03/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 10/01/2018               |


So the correct record to be returned would be #5



How can I achieve this using C#?



I have this so far:



    var recordsNextCouponPaymentAfterLastOfMonth = externalInterestForSecurity.Where(aExternalRecord => aExternalRecord.PayDate > priorMonthEnd);





c# linq







share|improve this question















This question already has an answer here:




  • LINQ OrderBy with more than one field

    6 answers




So I need to pull the record which matches the following criteria:



A record which has the lowest PayDate but also the highest ReconciliationDate.
An example of records can be seen like this



public class Data {

    public string Name { get; set; }

    public DateTime PayDate { get; set; }

    public DateTime ReconciliationDate { get; set; }

}



--------------------------------------------------

| Name   | PayDate    | ReconciliationDate       |

--------------------------------------------------

| Andrew | 11/14/2018 | 07/01/2018               |

--------------------------------------------------

| Andrew | 10/14/2018 | 06/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 08/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 03/01/2018               |

--------------------------------------------------

| Andrew | 05/14/2018 | 10/01/2018               |


So the correct record to be returned would be #5



How can I achieve this using C#?



I have this so far:



    var recordsNextCouponPaymentAfterLastOfMonth = externalInterestForSecurity.Where(aExternalRecord => aExternalRecord.PayDate > priorMonthEnd);




This question already has an answer here:




  • LINQ OrderBy with more than one field

    6 answers







c# linq




c# linq






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 14 '18 at 22:32









AndrewAndrew

346318




346318




marked as duplicate by Camilo Terevinto c#
Users with the  c# badge can single-handedly close c# questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 14 '18 at 22:40


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.









marked as duplicate by Camilo Terevinto c#
Users with the  c# badge can single-handedly close c# questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 14 '18 at 22:40


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.















  • You could sort the list with OrderBy, OrderByDescending, ThenBy, and/or ThenByDescending, then take the first row. See this question.

    – John Wu
    Nov 14 '18 at 22:38





















  • You could sort the list with OrderBy, OrderByDescending, ThenBy, and/or ThenByDescending, then take the first row. See this question.

    – John Wu
    Nov 14 '18 at 22:38



















You could sort the list with OrderBy, OrderByDescending, ThenBy, and/or ThenByDescending, then take the first row. See this question.

– John Wu
Nov 14 '18 at 22:38







You could sort the list with OrderBy, OrderByDescending, ThenBy, and/or ThenByDescending, then take the first row. See this question.

– John Wu
Nov 14 '18 at 22:38














1 Answer
1






active

oldest

votes


















0














You are looking for the LINQ methods OrderBy and ThenBy



In your case its



.OrderBy(x => x.PayDate).ThenByDescending(x => x.ReconciliationDate).First





share|improve this answer


























  • Select first one I think

    – Andrew
    Nov 14 '18 at 22:44











  • @CamiloTerevinto what do you mean half the answer? it's exactly what he needs.

    – DevEstacion
    Nov 14 '18 at 22:44


















1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









0














You are looking for the LINQ methods OrderBy and ThenBy



In your case its



.OrderBy(x => x.PayDate).ThenByDescending(x => x.ReconciliationDate).First





share|improve this answer


























  • Select first one I think

    – Andrew
    Nov 14 '18 at 22:44











  • @CamiloTerevinto what do you mean half the answer? it's exactly what he needs.

    – DevEstacion
    Nov 14 '18 at 22:44
















0














You are looking for the LINQ methods OrderBy and ThenBy



In your case its



.OrderBy(x => x.PayDate).ThenByDescending(x => x.ReconciliationDate).First





share|improve this answer


























  • Select first one I think

    – Andrew
    Nov 14 '18 at 22:44











  • @CamiloTerevinto what do you mean half the answer? it's exactly what he needs.

    – DevEstacion
    Nov 14 '18 at 22:44














0












0








0







You are looking for the LINQ methods OrderBy and ThenBy



In your case its



.OrderBy(x => x.PayDate).ThenByDescending(x => x.ReconciliationDate).First





share|improve this answer















You are looking for the LINQ methods OrderBy and ThenBy



In your case its



.OrderBy(x => x.PayDate).ThenByDescending(x => x.ReconciliationDate).First






share|improve this answer














share|improve this answer



share|improve this answer








edited Nov 14 '18 at 22:45

























answered Nov 14 '18 at 22:39









DevEstacionDevEstacion

1,58711024




1,58711024













  • Select first one I think

    – Andrew
    Nov 14 '18 at 22:44











  • @CamiloTerevinto what do you mean half the answer? it's exactly what he needs.

    – DevEstacion
    Nov 14 '18 at 22:44



















  • Select first one I think

    – Andrew
    Nov 14 '18 at 22:44











  • @CamiloTerevinto what do you mean half the answer? it's exactly what he needs.

    – DevEstacion
    Nov 14 '18 at 22:44

















Select first one I think

– Andrew
Nov 14 '18 at 22:44





Select first one I think

– Andrew
Nov 14 '18 at 22:44













@CamiloTerevinto what do you mean half the answer? it's exactly what he needs.

– DevEstacion
Nov 14 '18 at 22:44





@CamiloTerevinto what do you mean half the answer? it's exactly what he needs.

– DevEstacion
Nov 14 '18 at 22:44





-

Popular posts from this blog

Florida Star v. B. J. F.

Image
Florida Star v. B. J. F. From Wikipedia, the free encyclopedia Jump to navigation Jump to search United States Supreme Court case Florida Star v. B. J. F. Supreme Court of the United States Argued March 21, 1989 Decided June 21, 1989 Full case name The Florida Star v. B. J. F. Citations 491 U.S. 524 ( more ) 109 S. Ct. 2603; 105 L. Ed. 2d 443; 1989 U.S. LEXIS 3120; 57 U.S.L.W. 4816; 16 Media L. Rep. 1801 Prior history The Florida Star v. B.J.F., 530 So.2d 286 (1988) Supreme Court of Florida; Florida Star v. B.J.F., 499 So.2d 883 (1986) Fla. Dist. Court of Appeals Holding Florida Stat. § 794.03 is unconstitutional to the extent it makes the truthful reporting of information that was a matter of public record unlawful, as it violates the First Amendment. Court membership Chief Justice William Rehnquist Associate Justices William J. Brennan Jr.  · Byron White Thurgood Marshall  · Harry Blac
Read more

Error while running script in elastic search , gateway timeout

Image
0 while running script in elastic search, I got 504 Gateway timeout error. { "query": { "bool": { "filter": { "script": { "script": " doc['creted_date'].date.getMonthOfYear() == 12 " } } } }, "aggs": { "test": { "date_histogram": { "field": "creted_date", "interval": "month", "format": "MMM" }, "aggs": { "cost": { "sum": { "field": "cost" } } }
Read more

Adding quotations to stringified JSON object values

Image
0 My stringified object data doesn't include quotation marks around object values, which errors when attempting JSON.parse() : '{ "affiliation": CORPORATE, "userId": 75c35d1c-5d12-4485-8fa8-b2f1551a3e6e }' I need the string to be: '{ "affiliation": "CORPORATE", "userId": "75c35d1c-5d12-4485-8fa8-b2f1551a3e6e" }' I'm using this regex to add quotes to the object keys: var newStr = str.replace(/(['"])?([a-z0-9A-Z_]+)(['"])?:/g, '"$2": '); For instance: '{ affiliation: CORPORATE }' to '{ "affiliation": CORPORATE }' There are only string values in my data, so I don't need to check value types. How can I alter my regex expression to add quotations to
Read more