invoices.Select(i => new
{
FormattedDate = ( EntityFunctions.Right(String.Concat(" ", SqlFunctions.StringConvert((double?) SqlFunctions.DatePart("dd", i.DocumentDate))), 2)
+ "/"
+ EntityFunctions.Right(String.Concat(" ",SqlFunctions.StringConvert((double?) SqlFunctions.DatePart("mm", i.DocumentDate))), 2)
+ "/"
+ EntityFunctions.Right(SqlFunctions.StringConvert((double?) SqlFunctions.DatePart("yyyy", i.DocumentDate)), 4)
).Replace(" ", "0")
}
Sunday 28 December 2014
Formatting date in Linq-to-Entities query causes exception
Subscribe to:
Posts (Atom)