i am new to vb.net...
my problem in this query is that "Format is not a recognized built in name"
this Format() is an sql function right?
is there a header file to call the format() function just like c++?
can anyone help me with this? please!
here's my query code:
command2 = conn.CreateCommand
sqlString = "INSERT INTO checkinout_summary1 ( Userid, CheckTime, [Date], [IN], [Day] ) SELECT checkinout_Extracted1.Userid, checkinout_Extracted1.CheckTime, Format([CheckTime],'mm/dd/yyyy') AS [Date], First(Format([CheckTime],'hh:nn AM/PM')) AS TimeIN, Format([CheckTime],'dddd') AS DDay FROM checkinout_Extracted1 GROUP BY checkinout_Extracted1.Userid, checkinout_Extracted1.CheckTime, Format([CheckTime],'dddd'), checkinout_Extracted1.CheckType HAVING (((checkinout_Extracted1.CheckType)='I')) ORDER BY checkinout_Extracted1.Userid"
command2.CommandText = sqlString
'db2 = New sqlCommand(sqlString, conn)
check = command2.ExecuteNonQuery