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

    HI,

    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
    Posts
    1,771

    Default

    If you read the file as a date you can use the Calculator Step (Month of date A).
    http://wiki.pentaho.com/display/EAI/Calculator

    Else you can try the Modified Java Script:
    http://wiki.pentaho.com/display/EAI/...a+Script+Value

    Mick

  3. #3
    Join Date
    Feb 2011
    Posts
    840

    Default

    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.