Skip to Content
0

How to filter results up until a certain date without having a value in the database?

Oct 26, 2016 at 07:06 PM

43

avatar image
Former Member

I have a set of data which I want to see the total result for previous days, can I add a date filter to do this without using an actual field in the database?

I also have a lot of results that result in a 0 which I want to leave out of the report, how do I do this?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dell Stinnett-Christy Oct 26, 2016 at 09:04 PM
0

You would have to have some way of identifying the dates of the records - that's usually done through a date field.

To keep out the results of 0, you could add a selection formula that's something like this:

{Table.ResultField} > 0

-Dell

Share
10 |10000 characters needed characters left characters exceeded
Brian Dong Oct 26, 2016 at 09:20 PM
0

Hi James,

You could use CurrentDate -1 to get yesterday's dates like:

{table.DATEFIELD} = (CURRENTDATE - 1); 

If you wanted a range of days like the last 7 days then:

{table.DATEFIELD} In [(CURRENTDATE - 7) and (CURRENTDATE - 1)]; 

Brian

Share
10 |10000 characters needed characters left characters exceeded