Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 26, 2016 at 09:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2016 at 09:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded