Friends.

Greetings.

I am creating a view in SQL SERVER MANAGEMENT STUDIO 2008 EXPRESS using the following query which I copied from MS-ACCESS.
-------------------------------------
SELECT id, Cust_ID, id AS Expr1, Cust_Name, Rm, CDate(InDate & [ ] & InTime) AS InDateTime, SrvcID, InDate, InTime, InRcrdDate, InRcrdTime, SizeName,
HalaName, LocName, Qty, OutTime, OutDate, OutIqama, Days, CntNo, ExitTime, Deleted, NoCntNo, NoSize, NoHala, NoQty, OutNoCntNo,
DAMAGES_ID_1, DAMAGES_ID_2, DAMAGES_ID_3, DAMAGES_REMARKS, ISO_CODE, VESSEL_IN, VESSEL_OUT, VOYAGE_IN, VOYAGE_OUT,
SHIPPING_LINE_CODE, ETA_IN, Rem, ETA_OUT
FROM dbo.Daily
-------------------------------------

But unfortunately I am getting an error that "CDATE function in not an Inbuilt function".

Guys my task is to migrate the Access Database(including many tables and views)to SQL SERVER.

I was able to migrate everything, but the ACCESS Views are also migrated as an SQL Table.

So now I am manually creating the VIEWS in SQL.

It will be highly appreciable that if u could suggest me any ideas to migrate all the ACCESS QUERIES to SQL VIEWS.
or else Please help me with an alternate for CDATE() in SQL.

Thank You.