Hi all.
Having an SQL populate a sheet with data and time columns, I need to filter a pivot ...say.. (A:C) within a specific time/date range.
ie: Name (A1), Job(B1), Time-stamp (C1)
between:
1: Yesterday 06:00:00
2: Today 03:00:00
Value format in C is currently: dd/mm/yy hh:mm:ss
I am thinking of just putting an additional column (D) into the sheet (outside the SQL area) that will state "Last Shift" if the adjacent date /time stamp is between Today and yesterday BUT between specific times. I can then Pivot filter by "Last shift" and display all data during this period.
Somehow I need to add TODAY dd/mm/yy and "03:00" and compare etc
Anyway ... I'm stuck, I also have the difficulty of the time stamp displaying in serial if I add or change it.
VBA is also optional but probably a bit complex.
Thanks in anticipation.
Paul.