Date format + DB Schema

Date format + DB Schema

Hi Team,


I have following 2 questions


1)    I am creating the report and need to include this column “Status Comment” there is no delivered column  when I am creating the report. In which table Status comments are stored. Please see the screen shot below



2)    I am using SD plus in my office generating some report can't find the template for example Last Wednesday to this Wednesday( 1 week data Wednesday to wednesday)



CREATEDTIME >= <from_lastweek> AND wo.CREATEDTIME <= <to_lastweek> 


How I can pull the data for weekdays for example


CREATEDTIME >= <Last_Wednesday> AND wo.CREATEDTIME <= <To_thisWednesday> 


The following Templates are  not showing  this


Today - <from_today> - <to_today>

This week - <from_thisweek> - <to_thisweek>

Last week - <from_lastweek> - <to_lastweek>

This month - <from_thismonth> - <to_thismonth>

Last month - <from_lastmonth> - <to_lastmonth>

This quarter - <from_thisquarter> - <to_thisquarter>

Last quarter - <from_lastquarter> - <to_lastquarter>

Yesterday - <from_yesterday> - <to_yesterday>