I am trying to wirte an expression that does a count on the field [OwnerID] where the field [Date Termed] falls between the current_date and current_date -7 days. Ideally I would like if it just did a count on [ownerID] for the prior week.
i tried that code, but no luck. I am returning a value of 0. I also tried updating the days to look back to -100 and still nothing. I am certain I had users term within the past 100 days. Would it be any easier if i just needed the count for the previous week. Maybe use the InWeek() function?
If your data was in like a text format or a number format like 20130731 you'll have to use something like date#(FIELD, 'YYYYMMDD'). and then you can use date(date#(FIELD, 'YYYYMMDD'), 'MM/DD/YYYY') to get it in the format you want.
to get previous week, you could do something like: