on 07-17-2008 10:08 AM
Hi,
Is there a possibility to syndicate a Time Stamp field (which is only updated when certain field is updated) in local time instead of GMT?
Now when we syndicate this Time Stamp field, the format is: "07/14/2008 06:39:17 GMT"
We want this time stamp converted to our local time (GMT +1), e.g. "07/14/2008 08:39:17". (two hours difference because we are on summer time now).
Can this be done? If so, how?
Regards,
Marcel
Hi PHM,
Yes we can syndicate the Time.
To syndicate the time when any record is updated in GMT + 2 format ,u can go like this make a field in console as "Time".
Write a assignment by using "Systime" .This can be done in two ways
1) In MDM Console make the field as Calculated and then write the expression as below Systime(2/24)
2) In data manager
The format will be like for +1 hr as "Systime(1/24)"
For two hrs"Systime(2/24)".When ever u update a record after that add this assignment in the workflow as next step.
Hope this may help u.
And if ur MDM server time is not in GMT then make the above field as type "GM time" and then do as stated above.
Rgds
Ankit
Edited by: ankit jain on Jul 17, 2008 11:36 AM
Edited by: ankit jain on Jul 17, 2008 11:40 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ankit,
I also used the systime() function but that takes the system time as a basis (obviously!), while I need the timestamp field as a basis for the calculation (because I need exactly that same value of the timestamp field for the local time calculation)!
So I need somthing like this: Local time field (to syndicate) = Timestamp field + 2 hours?
And also, in summertime the difference is 2 hours with GMT. How can I make the distinction in the calculation between summertime and wintertime within that calculation (which is also future proof)?
Regards,
Marcel
Hi ,
I tried a lot but caome to the conclusion that in any way we cant fetch and use alter the "Time stamp" value,it is the property of this field.When ever we try to run any assignment on this it will take "GMT" time.So we cant make-up the req.If u can explain the scenario where u want to alter the time stamp by 2 hrs.
Rgds
Ankit
Hi Ankit,
I found one possible solution:
When I use a field of type "Literal Time" (e.g. Local Update Time) and put the following expression in an assignment for this field (where Update Date is a Timestamp field):
Update Date + (2/24)
This will add 2 hours to the Update Date (Time section). I can now use that field for syndication!
Problem I still have is with the summertime/wintertime difference, but I could add something for that based on the Update Date (e.g. if Update Date between certain dates it add 2 hours, else it add 1 hour)...
Thanks anyhow for your help. I will reward some points.
Regards,
Marcel
Hi,
Ya ur right we also tried same thing but insted of + (2/24) we are writing + 2,which is not giving time in correct format.Thanks fr help. Very gd qst from ur side.
Now u can write assignment as: if date between <> Sum(2/24) else Sum( /24) ( acc).
But there is a problem in this case ex when u will run the asignment the record time stamp will be updated with the time on which u have run the assignment.
Ex like u have updated a record at 10.00 a.m and run the assignment at 11.00 a.m then for the next time the Time stamp will be updated with the time 11.00 a.m. as assignment field updates the time stamp field.This will not allow u to know exact time of record update.
.
Thanks
Ankit
Edited by: ankit jain on Jul 17, 2008 2:20 PM
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.