on 12-13-2011 3:20 PM
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
Hello,
((Update Date - Update-GDS)>=0 s) AND( (Update Date - Update-GDS)<=900 s)
Try the above code this might help.
Regards,
Abhishek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.