topic Re: Get Weekday from Date in CDS View using Eclipse in Application Development and Automation Discussions

Get Weekday from Date in CDS View using Eclipse

former_member686194 — Mon, 07 Sep 2020 14:15:27 GMT

Derive the weekday based on the date.

Sunday = 1

Monday = 2

Tuesday = 3

Wednesday = 4

Thursday = 5

Friday = 6

Saturday = 7

if date is 12/31/2019 i.e Tuesday, output should be '3'

Re: Get Weekday from Date in CDS View using Eclipse

Sandra_Rossi — Mon, 07 Sep 2020 17:20:31 GMT

Something like that (ABAP CDS):

MOD( DATS_DAYS_BETWEEN( CAST( '00010102' AS abap.dats ) , yourdate ) , 7 ) + 1

NB: 0001/01/02 was a Sunday.

Re: Get Weekday from Date in CDS View using Eclipse

bpawanchand — Wed, 09 Sep 2020 08:06:35 GMT

Hi Tendulkar,

Please check below sample CDS view definition which gives exactly the result what you are expecting

@AbapCatalog.sqlViewName: 'ZV_RND_VIEW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'A Sample CDS View'
define view ZI_RND_VIEW 
with parameters p_date: abap.dats
as select from I_CalendarDate {
    //I_CalendarDate 
    CalendarDate, 
    CalendarYear, 
    CalendarMonth,  
    WeekDay
} where CalendarDate = $parameters.p_date;

the weekday is the field which gives you the number of the day

Thanks

Pavan Bhamidipati

Re: Get Weekday from Date in CDS View using Eclipse

Sandra_Rossi — Sun, 13 Sep 2020 18:39:44 GMT

If it's solved, can you tell us how you solved? Thx.

Re: Get Weekday from Date in CDS View using Eclipse

former_member686194 — Mon, 14 Sep 2020 09:13:24 GMT

Hello Sandra,
Greetings.
Sorry for replying late.

I implemented the above code and it worked. Thanks for your help!

Re: Get Weekday from Date in CDS View using Eclipse

former_member686194 — Mon, 14 Sep 2020 09:15:13 GMT

Hi Pavan,

Will check this code as well. However, the above code mentioned by Sandro is working as expected.

Thanks for your help!