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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

strange behaviour of DATE_GET_MONTH_LASTDAY with 01.12.2008

Go to solution
former_member186143
Active Contributor

‎06-03-2008 7:06 AM

0 Kudos

when I enter 01.12.2008 or 01.12.2007 in DATE_GET_MONTH_LASTDAY I get no result back

when I enter 01.11.2008 I get 31.11.2008

anybody knows what is happening here ? and how to fix this ??

kind regards

arthur

1 ACCEPTED SOLUTION

Go to solution
andreas_mann3
Active Contributor

‎06-03-2008 7:45 AM

0 Kudos

better use LAST_DAY_OF_MONTHS

3 REPLIES 3

Go to solution
rahul_kamble2
Participant

‎06-03-2008 7:45 AM

0 Kudos

Hi,

Its working when i checked.

Regards,

Rahul

Go to solution
andreas_mann3
Active Contributor

‎06-03-2008 7:45 AM

0 Kudos

better use LAST_DAY_OF_MONTHS

Go to solution
kimmo_sirpoma
Participant

‎12-14-2009 8:58 AM

0 Kudos

Your case was already solved and I don't need points, but in hope that some other developer might read this thread and would be using same fm DATE_GET_MONTH_LASTDAY as well, I give this warning: DATE_GET_MONTH_LASTDAY calculates wrong value (it returns no value at all) if month is December. A note 1063114 from year 2007 corrects this, but it is not necessarily corrected even in very latest SPs nor EHPs. My recent finding is from a fresh installed ECC6.0 system with EHP3. Thus beware if you use fm DATE_GET_MONTH_LASTDAY. Use other alternative fm's as was already provided in this thread.

Luckyly no SAP standard uses this fm anymore, which might be the reason why the note 1063114 is not applied even for newer SPs/EHPs.

br: Kimmo