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>

 

Regards,

Sanjay

                New to ADManager Plus?

                  New to ADSelfService Plus?