Using an Infopath form to gather downtime information for production lines. Form is date and timestamped using the NOW function. We run two, 12 hour shifts per day. Shifts start/end at 6am and 6pm. Within a 24hour period, there will be 2 dates to contend with, today's day and yesterday's date.
Want to create a view in my Sharepoint List that is based on the past 24 hours of entries. Have been unable to find a way to do this in Infopath or usinig Sharepoint filters. Any suggestions? TIA