Updating general date to short date in query

[CORTHOM]

If any one that can help me I have this simple database that I need to gather information and sort depending on carrier.

A field in one of the tables is set up for general date format and I need to create a query to update the field to short date.

I figured this is the only way since the information is being imported from excel in general date format.

If any one can help that would be greatly appreciated Im a beginner and this seems to be the only place I have been stuck on so far.

Some one posted on this website in 2006 this update format but it doesnt seem to work for me.

UPDATE TableName SET TableName.DateTimeField =
DateValue([TableName].[DateTimeField]);

my table name is RECAPS INPUTS
and my Field name is APPT.

What am I doing wrong ?
Thank you,

Corey

[CORTHOM]

forgot to mention this is how it is set up !!

UPDATE RECAPS INPUTS
SET RECAPS INPUTS.APPT = DateValue([RECAPS INPUTS].[APPT]);

[NeoPa]

@CORTHOM
That SQL is not good.

Try instead :

UPDATE [RECAPS INPUTS]
SET [RECAPS INPUTS].APPT = DateValue([RECAPS INPUTS].[APPT]);

Names with embedded spaces must always be enclosed within brackets ([]).

Welcome to Bytes!