SELECT subdate( curdate( ) ,date_format( curdate( ) ,'%w' )