SAP Knowledge Base Article - Preview

1876639 - SBOP BI 4.0: Web Intelligence functions LastDayOfWeek() and LastDayOfMonth() return different time if used with CurrentDate()

Symptom

  • The Web Intelligence formula FormatDate(LastDayOfMonth(CurrentDate());"dd.MM.yyyy HH:mm") returns correct value, ending the month by 00:00 time
  • The Web Intelligence formula FormatDate(LastDayOfWeek(CurrentDate());"dd.MM.yyyy HH:mm") returns incorrect value, not ending the week by 00:00 time
  • A formula with comparison of the Week end and Month end dates returns wrong results

 lastday.png


Read more...

Environment

  • SAP BusinessObjects BI platform 4.0 SP06
  • SAP BusinessObjects BI platform 4.0 SP06 Client tools: Web Intelligence Rich Client
  • Microsoft Windows Server 2008 R2

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3

Keywords

WebI, FormatDate, comparison, zero, time, date , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.