Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
Consider I have this following code in the edit script.
Let vDay = Num(today());
LOAD
RowNo() as Sno,
Date($(vDay) -RowNo() +1 ) as Day,
num(Rand() * 1000, ' #,##0.00' ) as Amount
AutoGenerate 365;
What I want in this code is a week number for each date based on month and year
Like for example
Sno,Day,Amount, WeeknoMonthly, weeknumberyearly
125,24-03-2016, 205, 4,14
Hope I am clear.
Thanks
Kiran Kumar
for week number Yearly see the below
for week number monthly see the below