I am trying to define a date range and am new to op='bw' and op='ew'.

This is what I am struggling with to get a date range of Sunday - Saturday
of the previous week (from this week): [Inline: database='condata',
layout='WeekEnding', maxrecords=1, op='bw',
'statusupdate'=(var:'last_week_start'), op='ew', 'statusupdate'=var:
('week_start'), search]

Thanks,
Mark

The entire code follows:

<!--Set Variable for the first day of the week (sunday)-->
[variable_set:'week_start'=(date_format:(Date_Subtract:(Date_GetCurrentDate),Day=(Date_GetDayOfWeek:
(Date_GetCurrentDate))), dateformat='%m/%d/%Y')]

<!--Set Variable for date range calculation-->
[variable_set:'days_to_end'=(math_sub:'7',(Date_GetDayOfWeek:
(Date_GetCurrentDate)))]
[variable_set:'last_week_start'=(math_sub:'7',(var:'week_start'),dateformat='%m/%d/%Y')]
[variable_set:'qtd_start'=(date_format:Date='10/01/01')]
[variable_set:'week_end'=(date_format:(Date_add:(Date_GetCurrentDate),Day=(var:'days_to_end')),
dateformat='%m/%d/%Y')]

<!-- Calculate date range and search for week ending -->
[Inline: database='condata', layout='WeekEnding', maxrecords=1, op='bw',
'statusupdate'=(var:'last_week_start'), op='ew', 'statusupdate'=var:
('week_start'), search]
[variable_set:'lw_total'=(found_count)]
[variable_set:
'lw_leads'=(field:'leadSUM'),'lw_qualifieds'=(field:'qualifiedSUM'),'lw_signeds'=(field:'signedSUM'),'lw_joineds'=(field:'joinedsum'),'lw_actives'=(field:'activesum'),
'lw_successes'=(field:'Successsum'),'lw_inactive'=(field:'inactivesum')][/inline]





-----------------------------------------------------------------------
To Unsubscribe: <mailto:LassoStudioDW-off@blueworld.com>
List Archives :
<http:////listsearch.blueworld.com/LassoStudioDWSearch.lasso>
Blue World Support Central : <http:////support.blueworld.com/>
Support Inquiries: <http:////support.blueworld.com/supportinquiry.lasso>
Note: Lasso Studio for Dreamweaver Talk is not an official technical
support forum.