Skip to Content
0
Former Member
Apr 24, 2007 at 12:28 PM

regarding splitting of dates

29 Views

hi i want to split the dates that will be entered by the user on the monthly basis.if there is any way of diing it please le me know

suppose i have a strting date as 15.06.2001 and the end date as 31.05.2002

then the output that i want is

15.06.2001 to 30.06.2001

01.07.2001 to 31.07.2001

01.08.2001 to 31.08.2001

01.09.2001 to 30.09.2001

01.10.2001 to 31.10.2001

01.11.2001 to 30.11.2001

01.12.2001 to 31.12.2001

01.01.2001 to 31.01.2002

01.02.2002 to 31.02.2002

01.03.2002 to 28.03.2002

01.04.2002 to 31.04.2002

01.04.2002 to 30.05.2002

any code or functional module to split the date ranges in this type of format will do

thanks and regards

ashish