This topic is locked
[SOLVED]

 AddHours to Datetime

1/17/2019 8:10:01 PM
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

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.