Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Last Working Day of Last Week

  1. #1
    Join Date
    Oct 2013
    Posts
    18

    Default Last Working Day of Last Week

    Hello All

    In one of my jobs I need to get the date of the last working day so I can pull the right files for the correct date. IE: if it's Monday I need last Friday's date. The Get System Info step has exactly what I need with a Get Last Working Day Of Last Week variable, but when I use it I'm given Thursdays date not Fridays... I looked into this and saw it was a fixed bug on version 5.1 but it looks like that version is not available yet (at least from what I can find to download). Is there any way to make it so I can set Fridays date instead of Thursday? I'm running out of time on this one and can't figure it out. Or is there a place to download version 5.1 that I'm just not seeing?!

    Thanks

    Link to bug report:
    http://jira.pentaho.com/browse/PDI-10549

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Maybe you can use a calculator step and add one day to those records?
    -- Mick --

  3. #3
    Join Date
    Oct 2013
    Posts
    18

    Default

    I was hoping there would be a better solution but I did use a calculator step to correct the bug. I've attached the transformation for anyone who is running into the same problem as I was.

    get_todays_date_and_friday.ktr

Tags for this Thread

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.