Smedgeweddy
New Member
I have an events that users can post and related comments can be added for each events, although i have my db engine resides in the server in Us but i am living in east Europe(Cy) and we have like 7-8 hours time differences. I am using Linq anonymous type for both Events and Comments so i like to know how to use DateAdd function to correct the time differences in the Datetime of comments especially. Here is the example of my linq expression;\[code\]var myEvents = from a in myEntities.AddEvents where a.Authorized == true orderby a.Id descending select new { a.Id, a.VenueName, a.EventType, a.Date, a.StartTime, a.EndTime, a.Address, a.Phone, a.Reviews (This is for "Comments" and where i stuck!) };\[/code\]Any ideas appreciated! Thanks