Skip to Content
0

SAP DATA SERVICES XI BO DATE FUNCTIONS. How to calculate SEMESTER ?

Nov 11, 2016 at 12:06 PM

62

avatar image
Former Member

Dear,
I need to impplement the Date Functions semester in the Query Transform but It does not exist but quarter yes:
quarter(Date_Generation.DI_GENERATED_DATE)


How can I implement the same for semester ?

How can I simulate a function "X" ? that returns me the semester using functions that exists

Maybe can I use a custom Function????

X (Date_Generation.DI_GENERATED_DATE) ?????'

Thanks in advance.
Kind Regards.
Antonio

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member
Nov 18, 2016 at 07:23 AM
0

Depending on your definition of semester, use decode function in combination with date functions, e.g.

decode(quarter(Date_Generation.DI_GENERATED_DATE) in (1,2), 1,2)
decode( month(Date_Generation.DI_GENERATED_DATE) between <your range for first semester>, 1, 2)

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Great answer !!!!! Spasivo :-)

0