I think I see the issue, In the table there is {VP_SCHEDULE.CURRPAYPERIODSTART} and {VP_SCHEDULE.CURRPAYPERIODEND} and they all show the same start and end date but in another column is the {shiftstartdate} and {Shiftenddate}and it list all times since we installed the system. So the table shows:
{shiftstartdate} {Shiftenddate} {shiftstartime}
{9/17/2008 9:00:00 AM} {9/17/2008 2:00:00 PM} {1/1/1900 9:00:00 AM}
{Shiftendtime} {CURRPAYPERIODSTART} {CURRPAYPERIODEND}
{1/1/1900 2:00:00PM} {9/16/2012} {9/22/2012}
{PREVPAYPERIODSTART} {PREVPAYPERIODEND}
{9/9/2012} {9/15/2012}
So I pulled all recods that have a shift start date and shift end date in the current pay period rather than stating that the current date is in the time period and it worked. One last thing Is there a way thet if the time is on the hour it can show just the hour. I tried to format the field but that does not work. I bascially want it to show something like:
7AM - 3:30PM.
2:30AM - 10PM
and formatting the field only gives me:
7:0AM-3:30PM
2:30PM-10:0PM
Thanks
KevV
Edited by KevV - 17 Sep 2012 at 10:41am