‎2011 Jul 26 4:34 PM
Hi Experts,
Please help to get the standard FM in SRM for adding number to date and getting next date excluding weekends.
Thanks in Advance.
Thanks,
Sahil
‎2011 Jul 26 9:00 PM
‎2011 Jul 26 9:00 PM
‎2011 Jul 27 1:19 PM
Hi Clemen,
Thanks for reply, but still my queries are not resolved. I didn't found the FM suits my requirement.
Thanks,
Sahil
‎2011 Jul 27 2:28 PM
This kind of custom FM can be created easily.
But if you want to use standard FM then "DATE_CONVERT_TO_FACTORYDATE" FM is good but you need a factory calendar id which has all working days and weekend days specified (also public holidays if required). Then call this FM in loop for a count of days and it will give working day after "entered date + number of days"
So if calendar has only weekdays and weekends specified, it will add number of days in specified date excluding weekends.
Thanks,
Murtuza