Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Calculated Default Date Parameter

    Try modifying the select to the following:

    SELECT GETDATE()-(DATEPART(dw,GETDATE())+2) %  7

    This should return the correct Thursday for both Friday and Saturday.

     

Viewing post 1 (of 2 total)