Joined: 26 May 2011
Online Status: Offline
Posts: 2
Posted: 27 May 2011 at 11:05am
Thank you so much for you reply.. I ended up figuring it out around 1AM last night using something very similiar in the record selection.
{PDIssues.ModDate}>=dateadd("h",3,{?rvRecDate}) and {PDIssues.ModDate}< dateadd("h",16,{?rvEndDat}) and ctime({PDIssues.ModDate}) in ctime(#03:00#) to ctime(#16:00#)
I started out with the first 2 lines testing 1 day at a time, it wasnt until I was doing a range of 2 days or greater that I had issues, because it would grab all 24hrs in the days between the 1st day and the last day.. adding the 3rd line resolved the issue.
Probably isnt the prettiest resolution.. but hey.. it worked :)
Thank you very much for taking the time to respond to my question
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum