Hello everyone!
I'm currently working on a solution that uses the date as a measure to indicate when a process is nearing completion.
Basically I use the datediff function to know how much time left. But the problem starts when I have a time in the datetime value that starts at 11am. The DateDiff Function return some unexpected value
For example:
I have a variable call CurrentTime with the DateTime value "Set(CurrentTime2, Text(Now(), DateTimeFormat.ShortDateTime24,"pt-BR"))", and a value returned from sharepoint that I'm using to do the sum.

The first and second item are correctly, but the others don't. Why this happen?
great thanks to all of you.