trouble formatting date on transfer to temp table

[BennyLinton]

I am trying to export into a temp table (all text fields because it will be going into a text export later) and I'm having difficulty adding 0:00:00 onto the value of "ApptdateLast" for the update... any ideas? Thanks! Benny

INSERT INTO cbt_Export_Temp ( TransactionType, ID, ApptdateLast )
SELECT "Add" AS TransactionType, "BC" & [TransId] AS ID, dbo_Info.ApptdateLast & " 0:00:00" AS ApptdateLast
FROM dbo_examInfo

 

[pr2-eugin]

BennyLinton, what happens when you try to append 0:00:00?

 

[spikepl]

What is "I'm having difficulty"? Your butt itches? We cannot guess. What is the problem? Say what the system said/did.