on 08-19-2010 4:22 PM
Hi ,
I want to compare system date and another date field , if the Date field < system date then result should be true else false , but if the date field and system date is the same i want the result to be false, Please suggest
i have this in my validation expression now
(ABS(SYSTIME(0)) > ABS(DATEFIELD))
Hi Shiv
The problem is this will return a TRUE value system date >= datefield, but i want a FALSE value , Any suggestion.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vig,
As you asked: I think its because i'm using SYSTIME(0) , it's comparing the system date and time both with the datefield. naturally it will be greater. is there any way to get only the systemdate .
Please explain ur code
Logic is simple: As SYSTIME(0) returns both date and time i.e YYYY:MM:DD:TIME
So in my logic i use LEFT(SYSTEIME(0),11) which returns only date 11 chars upto YYYY:MM:DD: and other side also LEFT(datefield, 11) returns date and hence only date is getting compared. So I am comparing only the systemdate of SYSTIME(0) with date of datefield.
Kindly revert if you still have any doubts.
Regards,
Mandeep Saini
Hi,
I just saw your thread regarding the Data comparison.
I am also trying to achieve the same functionality. But this doesnot work for me. Please can anyone help me.
Requirement:
1. If Updated Date is not to today's date - then validation is TRUE else FALSE.
2. Update Date is of type Time stamp.
We are using MDM 7.1 SP04
Thanks,
Priya.
Hi,
I didn't check into the system but did you tried this:
(ABS(SYSTIME(0)) > =ABS(DATEFIELD))
Best Regards,
Shiv
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.