Hello..

I have a form with the following configuration:
Active - True/False Type
Display on List

Bid Tab Year - Text Type
Required
Display on List
Default Value: [DateTime:Now|yyyy]
List of Values: 2020;2019;2018;2017;2016;2015;2014;2013;2012;2011;2010;2009;2008;2007;2006

Bid Date - Date Type
Required
Display on List
Output Format: MM/dd/yy

Tab Information - Rich Text (HTML) Type
Required
Display on List
Searchable

If I try to edit the existing entries in the form, I get the following error.  If I add a new entry, I can then go in and edit the new entry without any problems.  Thanks.. -Jeff

This is on the webpage:
Error: is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: The conversion could not be completed because the supplied DateTime did not have the Kind property set correctly. For example, when the Kind property is DateTimeKind.Local, the source time zone must be TimeZoneInfo.Local. Parameter name: sourceTimeZone ---> System.ArgumentException: The conversion could not be completed because the supplied DateTime did not have the Kind property set correctly. For example, when the Kind property is DateTimeKind.Local, the source time zone must be TimeZoneInfo.Local. Parameter name: sourceTimeZone at System.TimeZoneInfo.ConvertTime(DateTime dateTime, TimeZoneInfo sourceTimeZone, TimeZoneInfo destinationTimeZone, TimeZoneInfoOptions flags) at System.TimeZoneInfo.ConvertTimeFromUtc(DateTime dateTime, TimeZoneInfo destinationTimeZone) at DotNetNuke.Modules.UserDefinedTable.EditControl.ServerTime(String value) at DotNetNuke.Modules.UserDefinedTable.DataTypes.EditCreatedAt.set_Value(String value) at DotNetNuke.Modules.UserDefinedTable.EditForm.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

DNN Event Logs:
InnerException: The conversion could not be completed because the supplied DateTime did not have the Kind property set correctly. For example, when the Kind property is DateTimeKind.Local, the source time zone must be TimeZoneInfo.Local. Parameter name: sourceTimeZone

I just saw the error occur again for another user on another portal.  They're trying to edit something with a date/time entry; which, I'm not sure.

We're running DNNPE version 06.02.03 and F&L version 6.0.4.

I was using my host account and it's preferred time zone is GMT -5 Eastern Time.  This other account for some reason had GMT -8 configured.  I just changed it to -5, so I'll continue to monitor the logs, but the errors are occurring.

Thanks..

Found out what the issue is.

At one time for some reason, the field values were putting the timezone information in them; e.g. 2012-02-22T00:00:00-05:00, whereas new entries show up as 2012-02-22T00:00:00.

Manually editing this out resolves this issue.  I've tried creating an update statement (see below; on our development server currently), but it's not working.  Any ideas?

UPDATE UserDefinedData
SET    FieldValue = replace(FieldValue, '-05:00', '')
WHERE  UserDefinedRowId LIKE '8626'

P.S.  There's 9,723 rows with the time zone inforamtion. :/