2. ASPRunner.NET General questions
  3. [SOLVED]  AddHours to Datetime
This topic is locked
[SOLVED]

 AddHours to Datetime

 		1/17/2019 20:10:01
ASPRunner.NET General questions
jadach authorDevClub member

I am trying to add values to another table after record added. One of the values passed is values["DateTime"]
I need to add 4 hours to that value.
This does not work

dynamic tblCC = GlobalVars.dal.Table("dbo.CC");

tblCC.Value["DateTime"] = values["DateTime"].AddHours(4);

tblCC.Value["Slots"] = values["Slots"];

tblCC.Value["Added"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

tblCC.Add();


Any help would be most appreciated.
Thanks
Sergey Kornilov admin 1/17/2019

You need to convert values["DateTime"] to DateTime type first:

dynamic tblCC = GlobalVars.dal.Table("dbo.CC");

DateTime myDateTime = DateTime.Parse(values["DateTime"].ToString());

tblCC.Value["DateTime"] = myDateTime.AddHours(4).ToString();

tblCC.Value["Slots"] = values["Slots"];

tblCC.Value["Added"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

tblCC.Add();
jadach authorDevClub member 1/18/2019

Thanks. Works perfect.