on 01-10-2012 10:56 AM
Hi All,
Is it possible to compare MInutes or add minutes to the existing time stamp/system funciton in MDM? Say I have a field which holds the time stamp for which i need to add 5 minutes.. How can I add and then I need to compare ?
Thanks
Rajeev
Hi Rajeev,
You can compare 2 time stamp fields. There are implementations done where we need to compare start time and end time to check start time is always less than the end time. this can be achieved through Validations.
In a similar fashion, using assignments you can also add some value to the existing time stamp and assign the value to another time stamp.
Regards,
Sravan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajeev,
Try creating a validation expression like below
IF ((MODIFIED - CREATED)<3, TRUE, FALSE)
this expression will return true when the difference is less than 3 and else will return false.
Now create a workflow and add the branch to assign the above validation. Put the syndicate step for true and stop for false.
This should solve your purpose. let me know if it does.
Regards,
Sravan
Hi,
It Doesnt work as I need to check on minutes not days..
Suppose I have Create Time stamp as 12/1/2011 10:10:00 and Update Time stamp as 12/1/2011 10:13:00 it should syndicate.. If it is Create Time stamp as 12/1/2011 10:10:00 and Update Time stamp as 12/1/2011 10:13:03 it should not syndiacte...
Any suggestions.
Thanks
Rajeev
Hi Rajeev,
It will be a bit complex to compare two time stamp.
There is no direct way but you can do some workaround to achieve the same.
If your time stamp is showing 12/1/2012 10:10:00 then internal;y it is represented as 2012:01:12:10:10:00:000.
If you notice the length for date ,hour and minutes is fixed.What you can do you can write an expression using if then else where first you can check LEFT(Created,10)=LEFT(Modified,10),if this statement is truethen check hourand then compare minutes but here also you need to make many considerations like suppose your created time is 11:58:00:000 and modified is
12:01:00:000 and also suppose date is 2012:01:12:11:57:00:000 and modified time is 2012:01:13:00:00:00:000.
So when you write expression you need to use logical parameters and consider all the special cases as well.
Basicaly you have to play with functions and operators available.
But you can surely achieve it.
I hope it will give you some idea.
Regards,
Neethu Joy
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.