Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Trim time from date

  1. #1
    Join Date
    Jun 2006
    Posts
    282

    Question Trim time from date

    Hi Gents-
    I have a field from a flat file as yyyyMMddHHmm and the spec is set to date with that format. A rule states to use this field in place of service_date if the service_date field is null. Is there a way to lop off the HHmm portion without using JS?

    V 3.1.2 build 10064

    Darrin
    "If you want to increase your success rate, double your failure rate."
    Thomas Watson, Sr (former president of IBM)

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    3.2 has "Remove time from date" in Calculator.
    For 3.1.2 the trunc() method in JavaScript does the trick OR you can convert to String mask "yyyyMMdd" and back to date. Something like that would work too.

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.