Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Get the start date and end date

Former Member
0 Kudos
86

Hello folks,

Based on month and year, I need to get the start date and end date of that month. What is the FM used??

Points will be rewarded.

Thanks

2 REPLIES 2

former_member188685
Active Contributor
0 Kudos
36

hi first day you will get using month and year.

suppose

month is 03

year is 2005

then you will get first date as 03/01/2005.

send this date to FM LAST_DAY_OF_MONTHS

you will get the last date of month.

regards

vijay

0 Kudos
36

Once you have month and year,

concatenate YEAR MONTH '01' into G_FROM_DATE. It will be 01 anyway.

Then pass this date to FM LAST_DAY_OF_MONTHS and it will return the Last day of the month.

Good luck

Hari