Good day.
I have a grid that is bound to an ultraDataSource. The ultraDataSource has a string field for a date (short date). the wingrid's column style is set to DropDownCalendar.
when i have a new row within the grid, I receive a FatalException Error: "Internal error: can't get masked editor value. Inner exception is: Input does not match the mask." When i select the date, the value being put into the grid is, "//." (without the period)
I tried a couple of different mask options but that didn't fix it. If I edit a row that already has a date, it works fine - it only fails on a new row.
EDIT: the grid's version is 7.3.20073.1041
Please help.
thanks.
Hi,
Why store a date as a string? This will cause you all sorts of problems. You can't apply a Format to a string, it won't sort properly, adnd filtering will behave oddly from the user's perspective.
I recommend using a DateTime data type for the column instead of string.
I agree with you.
the database column is DateTime - the form itself; however, is stripping the time out. SQL allows an implicit conversion from char to datetime.
some of our tables cannot have the time in the field - when this is the case we use strings to denote not to include the time. if the datetime field has both the date and time, we don't use the string type.
thanks for the feedback - hopefully i can find the root cause of the FatalException Error. Unfortunately, I just heard that it doesn't raise the error on everyone's PC.
If you don't want the time part of a DateTime to show up in the grid, you can still use a DateTime field and then just set the mask to "{date}". The grid will hide the time from the user.
Is it possible to change the custom format for the datetime column to "MMM/dd/yyyy"
If I set like this, it is coming as MMM/19/2008 instead of Jan/19/2008
How to achieve this?