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!

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

Time comparison

Status
Not open for further replies.
maengler2000

maengler2000

Technical User
Feb 2, 2012
7
US
I am using CR2008.

I am trying to compare a time field to a specific time. I am having a hard time hard coding the time, doesn't like format.

table1.starttime > 07:30 am and
table1.endtime < 03:30 pm
 
Sort by date Sort by votes
Try:

Code: 
{table1.starttime} > Time(07,30,0) and
{table1.endtime} < Time(15,30,0)

Cheers
Pete
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
316
TPG_IT
T
POrlowski
  • Locked
  • Question
Calculating Sick Time
Replies
7
Views
247
POrlowski
POrlowski
nerdygirlgear
  • Locked
  • Question
Limit sub report records to a time range on main report 1
Replies
1
Views
95
hilfy
hilfy
GCL2007
  • Locked
  • Question
Date fields coming into Crystal as Date/Time 1
Replies
2
Views
114
GCL2007
GCL2007
NKOS13
  • Locked
  • Question
How do l convert audit time as per the format
Replies
1
Views
91
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top