Add week

[stephenedberkg]

I have the week format like this

12-50-2016

i want to add this week to 2.

[tresesco]

12 is month? 50 is week? How do you derive/interpret this week format?

[jonathandienst]

I suggest that you give some more examples and explain what you expect the week to be.

[stephenedberkg]

my date format is

MM-W-YYYY

11-46-2016

11-47-2016

each id have different lock period i want to add the lock period into week

if my lock perios is 1

i want like this

11-47-2016

11-48-2016

i am using mapping function

InvoiceDate  + ( ApplyMap('LockPeriods',ID,'Not matching'))   as INV_Lock,

11-47-2016     + 1

[tresesco]

Try something like like:

MakeWeekDate(SubField(InvoiceDate, '-',3), SubField(InvoiceDate, '-',2)   +  ApplyMap('LockPeriods',ID) ) as INV_Lock_Date,

[#6]

Hi Stephen,

Can you please see the below script. You will get the desired value.

input:

load * inline [

date

11-46-2016

11-47-2016

];

oo:

load SubField(date,'-',1)&'-'&RangeSum(SubField(date,'-',2),1) & '-'&SubField(date,'-',3) as ss 

Resident input;

Thanks,
Sreeman.

[stephenedberkg]

I tried but i cant get any values