string sFileName = @"C:\Working Directory\Product.xlsx";var excel = new ExcelQueryFactory(sFileName);excel.DatabaseEngine = LinqToExcel.Domain.DatabaseEngine.Jet;var per = from x in excel.Worksheet<Model1>("Product") select x;
When I look at the per (Model1) we can see that if the End Date is blank it will default to 20781231. So, it satisfied the requirement.
However, this question is a an extension of the previous question, in prods (Model1) for Product = 0002-0800 the End Date = 20340201 was selected. It should have been 20781231.
For the other Product (0002-1407, 0002-1975, 0002-3004, 0002-3227) it selected the correct End Date (latest end date for that product).
I think we're almost there with selecting the earliest and latest date with Model1.
If you've the time again please kindly take a look at this question:
Thanks again for your help!
0
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
All that would be needed is to modify your Model1 class as follows.
Open in new window
.