I'm having trouble getting my ASPX-App to work on the productive server. As my local environment is german but the server is english and my whole code didn't provide culture-support, I'm currently implementing that throughout the script.
As you might think, as I'm writing this in here, it doesn't quite work the way I want it to.
The App uses a MSSQL-Database for gathering information that is based on dateranges. So, I use the user-selected daterange for calculation using Date BETWEEN x AND y
.
The dates are set by the user and parsed in the script to datetime-values to be able to handle them:
_DateRangeStart = DateTime.Parse(DateStart + " 00:00:00", _Culture);
_DateRangeEnd = DateTime.Parse(DateEnd + " 23:59:59", _Culture);
Where _Culture
is defined as following:
public CultureInfo _Culture = CultureInfo.GetCultureInfo("de-DE");
and _DateRangeStart
(and End
) are the user-input from text-fields.
So, as I look into the skript, it shows me that the user input is transformed from 1.11.2009
(which is a correct german formatted date) to 11/1/2009 00:00:00 AM
, which should be 1.11.2009 00:00:00
(for _DateRangeStart).
This value cannot be read by the SQL and it gives me an error that converting a char to a valid datetime was not possible.
Why is the conversion not done correctly?