LAST DAY DATE OF LAST WEEK

[Former Member]

HI

  How to get Start day and last day of previous week in HANA SQL.

[Former Member · Accepted solution]

Hmmm...

Last weeks Monday

select  ADD_DAYS ( TO_DATE ('2015-02-20', 'YYYY-MM-DD'),  (  WEEKDAY( now() )   * -1 ) - 7  )    from dummy

or

select  ADD_DAYS ( now() ,  (  WEEKDAY( now() )   * -1 ) - 7  )    from dummy

etc

this weeks monday

select  ADD_DAYS ( TO_DATE ('2015-02-20', 'YYYY-MM-DD'),  (  WEEKDAY( now() )   * -1 )   )    from dummy

Last day is easy if you have first day