Hello,
Does anyone know how I could use a query to parse a date field. I'm importing from another device that uses a long date like 8/17/2006 10:04AM, but all I want is the 8/17/2006 part
Is there a way to do this with SQL or should I use some other approach.
P.S. I would like to incorporate it in an append query that I already have
Does anyone know how I could use a query to parse a date field. I'm importing from another device that uses a long date like 8/17/2006 10:04AM, but all I want is the 8/17/2006 part
Is there a way to do this with SQL or should I use some other approach.
P.S. I would like to incorporate it in an append query that I already have
