Skip to main content
A
Anonymous
November 3, 2010
Question

Get the week's start date

  • November 3, 2010
  • 2 replies
  • 507 views

How to get back the corresponding date according to 'ISO standard' while giving the week number and year as input. For example, Week=2 and year=2009, then result needed is 5-Jan-2009. Any function to achieve this?

    This topic has been closed for replies.

    2 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    November 4, 2010

    <cffunction name="getStartDateFromWeekNumber" hint="returns start date of the week, given the week number and the year">
        <cfargument name="weekno" required="yes">
        <cfargument name="year" required="yes">
        <cfset var startDate = dateAdd("w",arguments.weekno,createdate(arguments.year,1,1))>
        <cfreturn startDate>
    </cffunction>

    <cfset startDate = getStartDateFromWeekNumber(2,2009)>
    <cfset startDate_formatted = dateFormat(startDate, "dd-mmm-yyyy")>

    <cfoutput>#startDate_formatted#</cfoutput>

    R
    Reed_Powell-ttnmOb
    Inspiring
    November 3, 2010

    Have you looked on cflib.org?

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices