HomeForum
Welcome, Guest

Extracting year from Date field
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Extracting year from Date field

Extracting year from Date field 11 months, 3 weeks ago #2811

  • Mike
  • OFFLINE
  • Fresh Boarder
  • Posts: 12
  • Karma: 0
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

Re: Extracting year from Date field 11 months, 3 weeks ago #2812

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Use splitter transformation function

set format to delimited
and delimiter to /
Attachments:
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

If we compare to manual processing this program save more than 200 hours in month.

C Gandhi
Nesa-Canada

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top