https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/85050.aspxTue, 04 Dec 2012 12:50:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:85050TMOORE0https://www.infopathdev.com:443/forums/thread/85050.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=85050<p>Using an Infopath form to gather downtime information for production lines.&nbsp; Form is date and timestamped using the NOW function.&nbsp; We run two, 12 hour shifts per day.&nbsp; Shifts start/end at 6am and 6pm. Within a 24hour period, there will be 2 dates to contend with, today&#39;s day and yesterday&#39;s date.</p> <p>Want to&nbsp;create a view in my Sharepoint List that is based on the past 24 hours of entries.&nbsp;&nbsp; Have been unable to find a way to do this in Infopath or usinig Sharepoint filters.&nbsp; Any suggestions? TIA</p>