Hi All
I am fairly new to C# but normally can understand why something isn't working. However, I have a query that works as follows:
Whatever the date is in the DateTimePicker, return rows from MS Access database that are up to 7days ago and ahead (giving a 2 week window).
Query is written as follows:
String str = "SELECT [Date Submitted], [Category], [Description], [Estimated Time], [Day(s) Planned For] FROM WLP WHERE [Date Submitted] Between #" + DTP_DateTime.Value.AddDays(-7) + "# AND #" + DTP_DateTime.Value.AddDays(7) + "#";
Fairly simple query. I've used MessageBox to display the dates when -7 and +7 and they look absolutely fine. It's displaying the correct range.
An example is for today, show me all records between 06/08/2014 and 20/08/2014. However, it still returns results such as 01/08/2014, 04/08/2014, 05/08/2014. Interesting, if I change the date to way out the range, for example, 01/01/2014 it does not display it.
This lead me to believe it is a Culture issue as it's using it as an american date. I then added Thread.CurrentThread.CurrentCulture = new CultureInfo("en-GB"); to try and fix it but still no luck! Am I missing something incredibly easily!
Hope you can help! Thanks for your time in advance :-)
VulpesPosted Aug 13, 2014, 4:28 PM
06/08/2014 is being interpreted as 8th June 2014 but 20/08/14 is being interpreted as 20th August 2014 because, of course, there isn't a 20th month.
If you use the yyyy-mm-dd format then there should be no risk of it being misinterpreted so I'd try:
String str = "SELECT [Date Submitted], [Category], [Description], [Estimated Time], [Day(s) Planned For] FROM WLP WHERE [Date Submitted] Between #" + DTP_DateTime.Value.AddDays(-7).ToString("yyyy-MM-dd") + "# AND #" + DTP_DateTime.Value.AddDays(7).ToString("yyyy-MM-dd") + "#";