This probably not a staright forward one using msdb sprocs as you think,so you would need to work directly with msdb system tables

code like this might help you to create...

Same result with time..

select getdate() - datepart(day,getdate())