Records Between 5:00pm and 7:00am 1

[OldGrayMare]

Crystal XI = Version

I have a datetime field (SubmitDate)and need to select records in the last 6 months with a SubmitDateTime after hours, that is from 5:00 p.m. until 7:00 a.m.

How do I select that 5:00 p.m. until 7:00 a.m. timeframe?

Thank you!

 

[fisheromacse]

off of the top of my head, perhaps something like this:

(Time({Table.SubmitDate}) > 5:00pm and
Time({Table.SubmitDate}) < 11:59:59pm)
or
(Time({Table.SubmitDate}) > 12:00:00am and
Time({Table.SubmitDate}) < 7:00am)

 

[lbass]

A little clarification:

(
(
Time({Table.SubmitDate}) > time(17,0,0) and
Time({Table.SubmitDate}) <= time(23,59,59)
)
or
(
Time({Table.SubmitDate}) > time(0,0,0) and
Time({Table.SubmitDate}) < time(7,0,0)
)
)

...and then add your date criteria.

-LB

 

[OldGrayMare]

Thank you, Mr. Bass! You really ARE a genius. This solution works perfectly.

 

[fisheromacse]

good catch lb.
thanks