FW: linq and timezone conversion

[anthonyatsmallbiz]

 

     var issues = from n in db.vwIssues

                         where n.IsDeleted == false & n.Archived == false

                         orderby n.ETADate descending,n.PriorityOrder
ascending, n.DateModified descending

                         select new IssueViewModel

                         {

                             IssueId = n.IssueId,

                             IssueTitle = n.IssueTitle,

                             ETADate =
NodaTimeUtil.ConvertToMelbourneTimeZoneFromUtc(n.ETADate.Value), //doesn't
like it

                             Status = n.StatusName,

                         };

 

 

How do i achieve the above requirement, ie change date to local time as date
in db is UTC

 

 

Anthony Salerno | Founder | SmallBiz Australia
Innovation | Web | Software | Developers | Support
+613 8400 4191 | 2Anthony (at) smallbiz.com.au  | Po Box 135, Lower Plenty
3093 ABN : 16 079 706 737

www.smallbiz.com.au <http://www.smallbiz.com.au/>  |
www.linkedin.com/in/innovativetechnology

 

 

 

 

 

 

 

 

<<attachment: winmail.dat>>