How to transfers logic from Access SQL to below,
1. Select IIf(DLookUp("ServiceDate","sysUser")>=[ServiceDateStart] AND
[WeekDay]=Weekday(DLookUp("ServiceDate","sysUser"),2),1,0) AS ChkBusyRegular
From te
2. Select Weekday([ServiceDateStart],2) AS WeekDay
From te
Loading
mohit ranjanPosted Mar 4, 2013, 7:37 AM
just download software from
www.sqltolinq.com/
it will convert ur sql query to linq query
if it help u mark as answer