Removing Time from Date/Time Field

  • Thread starter Thread starter Matt.Russett
  • Start date Start date
M

Matt.Russett

Hello,

Here is what I am trying to do.

I am running a report that brings back Requested Pick-Up Times and
Actual Pick-Up Times. What I want to measure is the amount of times
the Requested and Actual fall on the same DATE. I don't care about
the time. I created a formula that says "If Requested = Actual , Then
1, Else 0" The idea is that I can sum all the 1's and compare to the
total number of shipments, and determine the On-time %.

My problem is with the Time coming back. My formula does not mark
1/1/2008 1:00 = 1/1/2008 2:30 because of the time difference.

How can i set it up so that my formula is only looking at the dates
for the match? I assume i will either need to somehow fix the formats
of the time prior to my current formula calculating. Or else have a
formula that only looks at the dates when computing.

Any help is appreciated!

Thanks,

Matt
 
Use the Date property of the DateTime class. For example:

Requested.Date=Actual.Date

Hopefully this helps. Good Luck!
 
Nevermind I found the answer...

if DateValue({OStops.RequestedDate}) =
DateValue({OStops.ArrivedDateTime}) then 1 else 0

The DateValue() was what I needed.
 
Back
Top