Data filtering..

[Jason Cramer \(OLSON & IVES\)]

Hi, I'm kind of new to this stuff, but I am pretty fluent in most
information technology.

I have a field that retrieves data from my sharepoint site's time clock
list. I have it filtering that data to only show the entries that match the
selected user, and only show the entries that have a value of "Clock In" in
the Clock In/Out column.



The data I'm retrieving is a Date & Time from a column showing what time the
clock-in or out took place.



I want to narrow down the results which are put into my new IN1 field data
source to show only entries in the specified pay period by applying the
following conditions:



I need to filter it FIRST by the month, so:



So if periodMonth (a calendar selector I've set up on the form) = February,
2006, then it shows all of the 2006-02-XX matches. Or, is it in a
MM-DD-YYYY format?

Anyway, I think I need to convert the formatting of the date that comes out
of this field to match the date format of my list.



THEN it narrows down all of the results by the 1st through the 15th OR the
16th through the 31st. I think I would do this by calculating a range based
on a value from whichPeriod.



whichPeriod is a drop-down with two values, First(1), Second(2)



If whichPeriod = 1, then it will show all of the XXXX-XX-01 through 15
matches.

If whichPeriod = 2, then it will show all of the XXXX-XX-16 through 31
matches.



Would it be easier to just put up two calendar date pickers to pick the
beginning and ending dates of the pay period?



I'm almost at the point of just having a column in my sharepoint list that
specifies a value for the pay period. That way I could filter any results
based on that column and wouldn't need to set up a special way for the form
to figure out which ones from a date range. This seems clunky to my
clock-in clock-out list for my users though.



Thanks for any help,

Jason

 

[S.Y.M. Wong-A-Ton]

I set up a similar solution filtering dates within an XML file by month and
then by a period within the month, and posted the solution here:
http://enterprise-solutions.swits.net/infopath/filter-list-current-month-period.htm

It might give you an idea of how you can go about getting the functionality
you need. The "Filter Data" option is available on drop-down list boxes and
on repeating tables when they're tied to the Main data source.