- Posts: 13
- Thank you received: 0
Extracting year from Date field
12 years 4 months ago #2811
by Mike
Extracting year from Date field was created by Mike
Help me please
I have a date field that I would like to transform or split it into 2 other fields
The source would be a field called [Date]
and the targets would be [Year] and [Month]
I currently do this manually in Excel with the functions YEAR and MONTH, can I accomplish the transformation in Adv ETL?
Sincerely,
Mike
I have a date field that I would like to transform or split it into 2 other fields
The source would be a field called [Date]
and the targets would be [Year] and [Month]
I currently do this manually in Excel with the functions YEAR and MONTH, can I accomplish the transformation in Adv ETL?
Sincerely,
Mike
Please Log in or Create an account to join the conversation.
12 years 4 months ago #2812
by admin
Mike
ETL Architect
Replied by admin on topic Re: Extracting year from Date field
Use splitter transformation function
set format to delimited
and delimiter to /
set format to delimited
and delimiter to /
Mike
ETL Architect
Attachments:
Please Log in or Create an account to join the conversation.