cancel
Showing results for 
Search instead for 
Did you mean: 

Assign constant time to field in DM

Former Member
0 Kudos

Hi SDNers,

The requirement is to do syndication via workflow at 7 pm GMT everyday.

Declared a field "Syn_Time" of type GM Time.

I need to assign a constant time, 19:00:00 to "Syn_Time" field via a assignment in the workflow.

Start -> Assignment -> Wait -> Syndicate-> Stop

The "Syn_Time" field is assigned to the "Wait" , so that the workflow goes to the Syndicate step only at the scheduled time.

I have tried assigning by using SYSTIME property, but this does not help in assigning the constant time. Since any calculation that is done using it will give different times based on the current time.

Any suggestions/workarounds.

Thanks,

Priti

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Priti,

You need to change TIME only to constant 19:00:00. Write in assignment Expression just as 19:00:00 rather than using it with SYSTIME . Just try it and revert with result if it helps..

Regards,

Mandeep Saini

former_member208981
Contributor
0 Kudos

Hi Mandeep,

Thanks for the reply.

I had tried it. The problem is on assigning the time, the date automatically changes to 01/01/1601. So, the syndication is set at 01/01/1601 19:00:00 , which does not again fullfill the requirement.

More suggestions/workarounds are welcome.

Thanks,

Priti

Former Member
0 Kudos

Hi Priti,

I got your requirement, you want to change only TIME and Date as current date , right?

Please use this below assignment Expression for the above requirement:

LEFT(SYSTIME(0),11)&19:00:00

On executing above expression, you will get result as 28/05/2010 19:00:00, it is working fine at my end.

Kindly revert with result.

Regards,

Mandeep Saini

Edited by: Mandeep Singh Saini on May 28, 2010 2:54 PM

former_member208981
Contributor
0 Kudos

Hi Mandeep,

Thanks a lot.. it works..

Can you suggest for the below expression:

If i want to increase the system date by 1 day and the time will be fixed again to 19:00:00 i.e 29/05/2010 19:00:00

Thanks again,

Priti

Former Member
0 Kudos

Hi Priti,

You can increase as many days on current date. As you want 1 day more than current date. Please use the below expression:

LEFT(SYSTIME(1),11)&19:00:00

It will give you desired result 29/05/2010 19:00:00, It is working fine at my end.

Kindly revert with result.

Regards,

Mandeep Saini

former_member208981
Contributor
0 Kudos

Hi Mandeep,

Great!! It works.

Thanks a lot,

Priti

Answers (1)

Answers (1)

Former Member
0 Kudos

Helo Priti

I suppose using outbond port MDSS (Syndication server) configured by syndicate daily in setup time will be more useful solution.

Regards

Kanstantsin Chernichenka

former_member208981
Contributor
0 Kudos

Hi Kanstantsin,

Thanks for the reply.

I have some validations to be performed on the records before syndicating them. Only those records which satisfy the validation will be syndicated. Therefore, workflow is mandatory to syndicate only the validated records.

Suggestions/workarounds are welcome.

Thanks,

Priti