Date Filter – Reports

Home Forum General Date Filter – Reports

This topic contains 11 replies, has 2 voices, and was last updated by  Nakia Brewer 5 years, 3 months ago.

Viewing 13 posts - 1 through 13 (of 13 total)
  • Author
    Posts
  • #6584

    Nakia Brewer
    Participant

    Hi Again, Can someone point me in the direction of how to implement an option to have a date filter on a report I am currently building?

    I.E. 2 Boxes, first Labelled Start Date and the Other End Date —> Button beside which then applies a filter to the Data Grid below that only shows form instances with a Last Submission Date that falls between the values entered in the 2 Boxes.

    #6588

    Use a Filter Input object and set for Day and Range. Please see our help guide: http://www.perfectforms.com/Documentation/manual/html/?adding_a_filter_input.htm

    #6597

    Nakia Brewer
    Participant

    Thanks,

    I did read through this but it doesn’t really define how to do what I need. I am confused as to how I link the 2 filters together (startDate – finishDate)

    I will have a further look today.

    Cheers

    #6600

    If you use a Filter Input object and set it to Date and Range it will give your users two date inputs (start and end).

    #6601

    Nakia Brewer
    Participant

    Also, forgot to ask.

    will this be looking at the {Meta – Last Submission Date} or can I specify to look at what I like (For example when the formInstance is first submitted I place the date into a Hidden FLD, could I direct the filter to look at that)

    #6603

    Yes you can.

    #6656

    Nakia Brewer
    Participant

    I found something a little annoying with this.

    The dayRange filter doesn’t have an option to change the format of the date! It is set to MM/DD/YYYY but we in Australia need it as DD/MM/YYYY! (Yes, I know it has a calendar selector but when it passes the result into the FLD its displayed as mentioned above)

    Its not a huge deal but maybe something that could be improved upon.

     

    #6659

    I will submit a development request on your behalf.

    #6660

    Nakia Brewer
    Participant

    Also,

    Something else that could be improved. If you set the FLD source of dayRange filter to a FLD that isn’t of type date but it still has a date value in it (like format “8 Aug 2013”) the lookup within the report hangs…

    Can be replicated by using a behaviour to placed util-CurrentDate into a FLD on a form on submission.. then subsequently build a simple report which has a dayRange filter linked to that FLD..

    Hope that makes sense???

    #6663

    What is “FLD”?

    #6664

    Nakia Brewer
    Participant

    Sorry, FLD = Text Input Field

    #6666

    A filter input cannot populate a Text Input Field. Therefore the format of a date range in a Filter Input should have no bearing. As you pointed out, it has a calendar selector.
    True, you cannot use a Text Input Field as a date source in a report.

    #6667

    Nakia Brewer
    Participant

    Okay thanks for your help

Viewing 13 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic.