DSXchange

I get the same warning as previous one when I use your trigger.I havn't checked that option.

Thank you for your replies ! I tried the trigger which gateleys posted.The job worked fine but gives the warning.When I unchecked the option Log Warnings after activities that finish with status other than ok in Job properties,the sequence runs without any warning. Also,I will try using UserVariable...

What to do to make my job work?

Hi I have a custom routine for dateconversion. When I run the sequence - ExecuteCommand Activity-Routine Activity-Execute command Activity.I am calling my routine in Routine Activity. It works fine when I trigger to Unconditional Expression type.But routine does not work when I give Ok condition Tri...

It may be because you dont have permission to compile that job.Try renaming that job & compile.If somebody else have created that job,try using their username & password .

gateleys wrote:All you had to do was take away the 'dash' in the format and rearrange the YMD to DMY-

Code: Select all

Oconv(Iconv(YourDate,"DDMY[2,2,4]") - 30, "DDMY[2,2,4])

Thank you so much.It works fine.

I hope you understand the overhead of calling your function for every row!! Why don't you just use the single line transformation? What's wrong with that? Sorry for my last reply.The code is not working.I can use your code but the concerns are about the Format.As I have the format as DDMMYYYY which...

No matter where you do the computation, the basic logic remains the same. Assuming your date is of the form 'YYYY-MM-DD', then as Craig pointed out, you can use - Oconv(Iconv(YourDate,"D-YMD[4,2,2]") - 30, "D-YMD[4,2,2]) I have the date format as 23012008[DDMMYYYY] . My code was iDat...

You don't need a routine for that - simply use IConv to convert to internal format, subtract 30 and then OConv back to whatever external format you'd like. ... Thanks for ur reply.Yes,If I do that in transformer stage,I can do that way.But I have to use this concept in Routine Activity Sequence &am...

You don't need a routine for that - simply use IConv to convert to internal format, subtract 30 and then OConv back to whatever external format you'd like. ... Thanks for ur reply.Yes,If I do that in transformer stage,I can do that way.But i ahve to use this concept in Routine Activity Sequence &am...

Hi

Can anyone help me write a custom routine?

I have a workdate & from the workdate I should get a date 30 days ago.


Thanks !