LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Weeknum

    Employee
    Posted 06-17-2015 00:04

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: a7n

    Trying to get the week num for a given week of the year where week is from Saturday to Friday

    example from excel 17/06/2015 ==WEEKNUM(A1,15)

    Which function should i be using ?


  • 2.  RE: Weeknum

    Employee
    Posted 06-17-2015 00:20

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ThomasT

    Hi a7n.

    Try this:

    node:Filter_7
    bretype:core::Filter
    editor:sortkey=55811f4e338f3cbc
    input:@40fd2c74167f1ca2/=Static_Data.40fe6c55598828e5
    output:@40fd2c7420761db6/=
    prop:Script=<<EOX
    Week = 'Date'.date("DD/MM/CCYY").week()
    emit *, Week

    EOX
    editor:XY=400,430
    end:Filter_7

    node:Static_Data
    bretype:core::Static Data
    editor:sortkey=55811f0c13b46d3e
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    Date
    16/06/2015

    EOX
    editor:XY=320,430
    end:Static_Data