Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My scenario is, I have to extract rate of products on each date of calendar. And I have only From Date, To Date, Product Code, and Rate.
In this I have two cases,
Case 1: Old Rate of Product is in between From Date and To Date.
Case 2: Rate of Product on current date is (date greater than From Date and To Date is '01-01-1900')
I am unable to handle this situation.
Kindly Help me on the same.
Thanks in advance.
Regards,
Shivani Singhal
Hi Shivani,
I would handle this scenario as below.
Below syntax generates dates monthly wise
Load
*,
AddMonths(MonthStart([Start Date]),iterno()-1) as Date,
Resident MainData
while AddMonths(MonthStart([Start Date]),IterNo()-1) <= MonthStart([End Date])
Let me know if this helps !!
--Priya