Skip to Content
0
Former Member
Dec 13, 2011 at 03:20 PM

How to get the time difference (in seconds) between two timestamp fields?

75 Views

Hi All,

I'm exploring validation expressions in SAP MDM Data Manager version 7.1.07.245

I have two timestamp fields, suppose Update Date and Update-GDS.

What I'm trying to do is prompt a warning when:

(Update Date minus Update-GDS) is greater than or equal to zero seconds

AND

(Update Date minus Update-GDS) is less than or equal to 900 seconds

the bottomline is, Update Date must be equal or greater than to Update-GDS but Update Date must not exceed 900 seconds difference.

my initial try was:

(Update Date - Update-GDS)>=0 s AND (Update Date - Update-GDS)<=900 s

But it always returns true even the time difference between update date and update-gds is beyond the condition.

Can you please guide me through this?

Thank you very much in advance.

Regards,

~erwin