Calculate last friday date with timestamp ssis

• dallas13

  SSCertifiable

  Points: 7491

  More actions

  June 13, 2019 at 10:11 pm

  #3653558

  hello,

  i want to calculate last friday’s date in ssis with timestamp. Below gives me only date. Can u help?

  DATEADD("dd", -1 - (DATEPART("dw", getdate()) % 7), getdate())

   

  Also 2) i want to find last friday until 3 pm.

  How to do that?? Thanks a lot

• jonathan.crawford

  SSCertifiable

  Points: 6612

  More actions

  June 14, 2019 at 12:23 pm

  #3653759

  duplicate post, see https://www.sqlservercentral.com/forums/topic/calculate-last-friday-date-with-timestamp-ssis

  -------------------------------------------------------------------------------------------------------------------------------------
  Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses