compre two date with time (1 Viewer)

[benjamin.weizmann]

hi :0
how can I compare two dates but ignore the seconds?!
(just the date... hours and minutes)

thanks!
Ben

 

[lokanathas]

Use this in build in function

FormatDateTime([Table1]![Day],2) & FormatDateTime([Table1]![Day],4)

 

[arnelgp]

use Format() function.

If Format([Date1],"yyyymmddhhnn")=Format([Date2],"yyyymmddhhnn") then
...
else
end if

 

[The_Doc_Man]

What were you doing with the difference? Is it for display only (and you are done with it at that point) or is the difference going to be used in further computation down the road?

Also, are you looking for a difference based on a 24-hour day or an 8-hour work day allowing for weekends?

Knowing your subsequent intent and the "scope" of the day in this problem makes a huge difference in the correct answer.