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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TIME DIFFERENCE

Status
Not open for further replies.
woolade

woolade

Technical User
Nov 8, 2001
51
AU
Is there a formula to use that allows you to calculate the difference in minutes between the time in a Date Time field and midnight of that same date?

Thanks

woolade
 
Sort by date Sort by votes
Try:

datediff("n", cdatetime(year({table.datefield}),month({table.datefield}),day({table.datefield}),0,0,0),{table.datefield})

Note that midnight of the same day is 12:00AM, which means that it's earlier.

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
208
hilfy
hilfy
POrlowski
  • Locked
  • Question
Calculating Sick Time
Replies
7
Views
349
POrlowski
POrlowski
nerdygirlgear
  • Locked
  • Question
Limit sub report records to a time range on main report 1
Replies
1
Views
138
hilfy
hilfy
GCL2007
  • Locked
  • Question
Date fields coming into Crystal as Date/Time 1
Replies
2
Views
200
GCL2007
GCL2007
Fermo Zolli
  • Locked
  • Question
Difference in hours for badging date and time activity
Replies
13
Views
230
Fermo Zolli
Fermo Zolli

Part and Inventory Search

Sponsor

Back
Top