Calculating Dates based on weeks from last Friday date
Good Day,
I hope someone would be able to assist me, I am looking to built a routing table from dates.
By having a pinned date, I would need to be able to generate dates based on the indicators.
For example, if I have an indicator called EV1, then every week from the pinned date, a date needs to be generated, if I should have an indicator like W13, then from the pinned date, there should only be one date generated for 13 weeks ahead.
Could someone please advise me if the above would be possible?
Not sure if u understood your issue clearly but you can add the value to be added in a loop and just add it . For EV1 you create a date after a week so pass the value as 7 for EV13 it should be 13 weeks ahead so it should be 91 put the number you want to add in each categotry and loop it