Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XI Current Date Time range 1

Status
Not open for further replies.

Xenophobe74

Technical User
Aug 29, 2005
4
US
Hey guys,

I am a newbie to this site and hope someone can point me in the right direction. I am creating a report that requires the output to report on any changes made to a system for the current date between the times of 8:00 AM and 3:30 PM. I am trying to use a function that will accomplish this but I can't quite find anything to get what I need. I have been digging in manuals and reading the help pages for a few hours and not finding exactly what I need. Any suggestions>

Thanks!
Brad
 
Try a record selection formula like:

{table.date} in datetime(currentdate, time(8,0,0)) to
datetime(currentdate, time(15,30,0))

You might want to make the end time time(15,29,59)--up to you.

-LB
 
That's exactly what I needed. Thanks for taking the time to respond so quickly. I try to figure things out on my own before disturbing the masses. I am a Oracle Database guy that has been thrown into creating Crystal Reports and Crystal is a little like learning a new language :( Thanks for giving the new kid on the block a little love :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top