Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Extracting month from a date column

  1. #1

    Default Extracting month from a date column


    I want to extract month from a date column. I tried taking substring and split field. It works.
    But is there any other proper way to do this?
    I tried Month() function in formula step.
    I gave it like Month([ColumnName]) and Month(Date([ColumnName])). It dint work.

    Please help.

  2. #2
    Join Date
    Apr 2008


    If you read the file as a date you can use the Calculator Step (Month of date A).

    Else you can try the Modified Java Script:


  3. #3
    Join Date
    Feb 2011


    as Mick said, Calc Step would be the better way to do it.

    Try messing around with Calc and you'll find it can do a LOT more than it appears to...
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.