I have a table that has a birthdate field inside of it. The vast majority of these records are just the year (example: "1975") There are a few records that have an actual date stamp (example: "04/04/1980")
Here is my issue.
I am running this through ETL. I need to either trim the date to just have the year marker or add "01/01" to the existing years to standardize. I have tried script components to append the 01/01 and I have tried data conversion and derived columns, none of which are working. Is there something else I may be able to do to approach this?