Offsetvalue causes incorrect backend data (SQLServer)

[Michael]

When setting an offsetvalue our on-line calendar performs correctly but the backend data (SQLServer) is incorrect.  If offsetvalue is -07:00:00 all appoitments in our database will be off by 07:00:00 hours.

Setting SelectedDate:
      Dim start As DateTime = DateTime.UtcNow.[Date]
      RadScheduler1.SelectedDate = start

Setting offsetvalue
      RadScheduler1.TimeZoneOffset = TimeSpan.Parse(offsetvalue)

Am I setting the SelectedDate incorrectly? 

Thanks in advance

[Yana]

Hi Michael,

Thank you for conctacting us.

For the described scenario, you should send dates in UTC format to the database.

Hope this helps.

All the best,
Yana
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Marc]

Thanks for the reply. 

Could you expand on "send dates in UTC format to the database"?
Is this a database change or back-end code?

[Yana]

Hello Marc,

If you want your appointments to be saved in database in the way you send them, you should set  TimeZoneOffset  to 0.

Hope this helps.

Greetings,
Yana
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Marc]

Thanks for the response Yana. 

Yes, setting my offsetvalue to 0 does give me correct database values.  But the on-line calendar ends up being off.

The end result I am looking for is:
Calendar Reads -7:00:00 (PST-US)
Database Entry Reads -7:00:00 (PST-US)

thanks

[Yana]

Hello Marc,

I suggest you hook to the AppointmentDataBound and AppointmentInsert/AppointmentUpdate events to edit dates in the way you need and to save them in the database.

Greetings,
Yana
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center