TestLab: Tricky filter on Execution Date
My requirement is to Filter the Execution Date column by last 12 hours of day-1 and first 12 hours of day-2. (Both the days are consecutive)
For ex, From 12:00:01 PM of 16 Feb 2010 To 17 Feb 2010 11:59:59 AM of 17 Feb 2010.
I tried the following filter in QC manually, it doesn't through any error, but it's actually filtering on both the complete dates. It's ignoring the time component.
>="02/16/2008 12:00:01 PM" AND <="02/17/2008 11:59:59 AM"
It would be of great help to me, if you can provide solution if any of the below three ways
1) Manual filtering in test lab
2) VB Code - OTA
3) VB Code - SQL query