Hello, We need a report that can distiguish between days of the week....specifically we are in need of a report that show Saturday and Sunday sales for the last two years... Please email at snipped-for-privacy@zcollectionsf.com if you can help... Thank you, Diana
Weekend Sales Report
Oct 22, 2009
1 Replies
Add this Weekday column to your report, and then you can add filter: Weekday=Saturday or Weekday=Sunday.
Begin Column FieldName = "Weekday" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Weekday" VBDataType = vbString Formula = "case datepart(w,[transaction].time) when 1 then 'Sunday' when
2 then 'Monday' when 3 then 'Tuesday' when 4 then 'Wednesday' when 5 then 'Thursday' when 6 then 'Friday' when 7 then 'Saturday' end" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2115 GroupMethod = groupmethodNone ColFormat = "" End Columnor you can change the selecti> Hello,
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required