DSXchange

I am coming to the conclusion that using =, <>, < or > is mostly harmful. There are occasions when it is OK, such as when one side of the comparison is a literal string containing non-numeric values (e.g. flag="Y"), or other circumstances when you know for certain that the values will nev...

hi, I need to pass a set of email address as a start loop activity in the Job sequence.when i tried giving as paramter by giving the file name as parameter i didn't work.any suggesstion on that. thanks, RK you can simply add a user variable stage in the starting of your sequence. In that user varia...

Holidays - of necessity - must be table (or hashed file) driven. Some holidays change year to year, such as Ramadan or Easter. Left(Oconv(TheDate, "DWB"),1) = "S" is a convenient test for a weekend day in English. Hi, Actually i have to take care of weekends only. For rest all h...

Hi,

Actually folder stage is not meant for defining the columns or fields of database. It is for defining 2 fixed columns, 1st is the input file name with entire path, and 2nd is the name given to the contents.

[quote="parag.s.27"][quote="ArndW"]kcs,

Hey Thanks to all of you. It finally worked. I just made a Routine for it.

Thanks

kcs, I like your suggestion, but if you stick with DW conversion and an integer you can make your logic simpler, this assumes you will make your order go to the Friday before a weekend, see: StageVar "DW" = OCONV(Date()+30,'DW') StageVar "DWCorrection" = IF DW >5 THEN DW-5 ELSE ...

You would use the OCONV function and the 'DW' conversion to get the DOW with 1 being Monday. IF OCONV(DATE()+30,'DW') >5 THEN "Weekend" ELSE "Weekday" Hey thanx Arndw, Just one more trouble i wanted to give you. 1st is what value should be for "Weekend" and "Weekd...

There are many ways of doing this and the optimal one depends upon the type and format of your source and where you are doing this comparison. How do you want to add a month? Add 30 days or take the current date and change the month part. If it does fall on a weekend, do you want to take the Friday...

Hello, i am migrating data from SUN ERP to SAP for Purchase Orders . The condition is delivery date should be, Current system date + 1 month . But the problem is after adding 1 month, the resulting date should not have a day falling on Saturday or Sunday. Is there any function or routine for this