XI Current Date Time range 1

[Xenophobe74]

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

 

[lbass]

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

 

[Xenophobe74]

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