FieldA and FieldB are being pulled from an ODBC connection, and both fields are formatted as Date/Time.
FieldA = 1/26/2015 00:01:00
FieldB = 1/25/2015 21:57:02
I'm trying to use an expression to show the difference.
FieldA - FieldB = 20357.56
What is this?
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Actually what is your expected result?
Expected result should be in Days or Minutes or Seconds or in which format?
Use concerned functions with the field based on your expected result.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
All of the digits are correct; the colons are missing...
Ben Van Johnson
Holy crap.Originally Posted by protonLeah
I knew it wasn't the correct decimal. I even double checked counts of seconds, minutes, hours, etc.
Final answer: FieldA - FieldB = 2 ":" 03 ":" 57.56
You get a gold star. Whoever designed this database gets a brown star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks