Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the week format like this
12-50-2016
i want to add this week to 2.
12 is month? 50 is week? How do you derive/interpret this week format?
I suggest that you give some more examples and explain what you expect the week to be.
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
Try something like like:
MakeWeekDate(SubField(InvoiceDate, '-',3), SubField(InvoiceDate, '-',2) + ApplyMap('LockPeriods',ID) ) as INV_Lock_Date,
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.
I tried but i cant get any values