Dim d = From Leave In db.trn_Leave_Request Join Emp In db.mst_Employee On Emp.EmplCode Equals Leave.Emp_Code
Join Leavetype In db.mst_LeaveType On Leavetype.Id Equals Leave.Leave_Id Order By Leave.Leave_App_Date
Select New With
{
Leave.Id, Leave.Leave_Month, Leave.Leave_App_Date,Leave.Leave_From_Date,Leave.Leave_To_Date, Emp.EmplName, Leavetype.LeaveDesc, Leave.Leave_Day
}
in above query i have to use alias name for a column and how to select only date for the column from date and to date
please help