Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Calculate date from calendar week and year

  1. #1

    Question Calculate date from calendar week and year

    Hello,
    is it (simply) possible to calculate the (beginning) date of a calendar week, that's given ? I want to calculate the date within a javascript-step.

    E.g.: Year = 2007, CW = 43
    Calculated Date: 22/10/2007 (DD/MM/YYYY)

    Is there any solution ?

    Thanx !

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

    Default

    format "w yyyy" is: "week of year" + "year".
    For example:

    str2dat("43 2007", "w yyyy") gives you 2007/10/15, a Monday.

    HTH,

    Matt

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.