cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member283957
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member220897
Participant
0 Kudos

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)

former_member283957
Participant
0 Kudos

Great answer !!!!! Spasivo 🙂

Answers (0)