Method Community

Hey Ryan, I was trying "Between" before without luck, "Within date range" looks like it does what I want. Thanks for the help. Any info you have on the differences would still be useful.

 Hello Kandy, To link 2 tables you can use linked fields. Please refer to the following post to learn more about linked fields and how to use them: http://www.methodintegration.com/cs/forums/p/381/1191.aspx#1191 For the 2nd part of your question on how to add a date filter to a report, you can do this in the 'Generate Report' ...

If I want to get data from Transaction and Bill Line Item tables how do I join and get a dataset ? I also wantto know how to add a date filter to  the report so that user can select a date range and this date range to be part of the data selection criteria?   Thanks 

If you visited our website in the past day or so, you might have noticed something new... perhaps something exciting that caught your eye.   If you have no clue what I am talking about, then you’ll definitely want to check out the “Tour” pages to see our 3 brand spanking new Method Edition videos!  You’ll ...

Matt, I'll look into this and get back to you.  

Hey Matt, Sorry I wanted to correct my last post, I was looking at another screen. For what you are doing you would want to use "Within Date Range". I am looking into what the advantages are and will post it on here once I finish.

 Hey Matt, I would use "Between" for now, I am getting some more details on this topic and will post more information when I get it.

 I am trying to filter a grid so that only items between 2 dates show in the grid. I added 2 Datepicker objects to be my To and From dates to filter within. What is the difference between using the "within Date Range" filter and the "Between" filter? Which one should I be using in this case?

Hi Cindy, Can you try dragging the fields you have in the Group Header section into the Detail section? Usually labels are added to the Group Header section to denote the name of the fields in the Detail section. Try this out and let me know if it helps. Also I'm not sure where the 'Filter String Editor' you are referring to is ...

HI Amanda, Sorry for the delay in checking this out. 3. The time does not get copied over to the second field, only the new date portion.  2. If the "Use today's date/time" checkbox is not checked in step 1 and none of the checkboxes are checked in step 4... when I select a date, the correct date is selected, but the ...