nerdexam
SAP

C_BOWI_40 · Question #21

Which DaysBetween() function syntax should you use to calculate the number of years since your birth, assuming the date object is Birth_date?

The correct answer is C. =DaysBetween([Birth_date] ; CurrentDate() ) / 365.25. Tests knowledge of correct SAP BusinessObjects Web Intelligence formula syntax for the DaysBetween() function, including proper argument separator and function call notation.

Using Formulas and Variables

Question

Which DaysBetween() function syntax should you use to calculate the number of years since your birth, assuming the date object is Birth_date?

Options

  • A=DaysBetween([Birth_date] ; CurrentDate ) / 365.25
  • B=DaysBetween([Birth_date] , CurrentDate() ) / 365.25
  • C=DaysBetween([Birth_date] ; CurrentDate() ) / 365.25
  • D=DaysBetween(CurrentDate() ; [Birth_date] ) / 365.25

How the community answered

(38 responses)
  • A
    5% (2)
  • B
    3% (1)
  • C
    92% (35)

Why each option

Tests knowledge of correct SAP BusinessObjects Web Intelligence formula syntax for the DaysBetween() function, including proper argument separator and function call notation.

A=DaysBetween([Birth_date] ; CurrentDate ) / 365.25

CurrentDate is written without parentheses, making it an invalid function call - it must be CurrentDate() to return the current date value.

B=DaysBetween([Birth_date] , CurrentDate() ) / 365.25

Uses a comma as the argument separator, which is invalid in Web Intelligence formula syntax - semicolons are required as separators.

C=DaysBetween([Birth_date] ; CurrentDate() ) / 365.25Correct

In Web Intelligence, function arguments are separated by a semicolon (;), not a comma. Additionally, CurrentDate must be written as CurrentDate() with parentheses to invoke it as a function that returns today's date. Dividing by 365.25 accounts for leap years to convert days into years.

D=DaysBetween(CurrentDate() ; [Birth_date] ) / 365.25

The argument order is reversed; DaysBetween() calculates from the first date to the second, so placing CurrentDate() first and Birth_date second would produce a negative result for past dates.

Concept tested: Web Intelligence DaysBetween formula syntax and separators

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/09382741016d40bda21f1c28edcf4660/46d8cc4e6e041014910aba7db0e91070.html

Topics

#DaysBetween function#date functions#formula syntax#CurrentDate

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice