Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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)
    
    
    Add comment
    10|10000 characters needed characters exceeded