Update Query for partial data

[rangersedge]

How do I get an update query to only copy part of a fields value?
For example: The original field has a date in month, day, and year. I only want to update the new field with only the year.

 

[pr2-eugin]

Could you please provide some sample data.

 

[rangersedge]

After importing an XML file. I have a table with a date of "1980-12-31 00:00:00". I want to put the Year portion of this information into another table.

 

[pr2-eugin]

You could use Year() function?

 

[rangersedge]

Do I put that in the updateto field? The XML imports into the table as short text by the way.

 

[pr2-eugin]

Yes. (I guess?) You might want to use CDate if it is short text.

 

[rangersedge]

That worked. I used Year(CDate([FieldName])) and it worked perfectly. Thank you.

 

[pr2-eugin]

No problemo