Wrong Routine value returned

[snassimr]

Hi !

I invoke routine from Job Sequence and pass value to job.
When I test routine it return right value.
But when I see in Director Job Parametr the value is returned wrong

TempDateN=(SDTToDateNumeric('2001-01-01') )
TodayDateN=(SDTToDateNumeric('2003-01-01') )

IF TempDateN<TodayDateN THEN Ans=TempDateN else Ans=TodayDateN ;

In roitine test the value is 20030101 but in log of job 20010101

Anu ideas?

Thanks in advance

[ketfos]

Hi,
You are getting through the job sequence the correct value.

TempDateN=(SDTToDateNumeric('2001-01-01') )
TodayDateN=(SDTToDateNumeric('2003-01-01') )

IF TempDateN<TodayDateN THEN Ans=TempDateN else Ans=TodayDateN ;


As '2001-01-01' is less than '2003-01-01', the answer is '2001-01-01' ?

Do you expect something different?

Ketfos

[Sainath.Srinivasan]

Your logic appears to be defined to pick the least of the 2.

The result is therefore the least of the two.

[ArndW]

So what does this SDTToDateNumeric routine do? Plus you don't want to use the ( ) around your function, either.

[snassimr]

Sorry I mistake in my formulation

In roitine test the value is 20010101 but in log of job 20030101

My SDTToDateNumeric('2001-01-01') return 20010101

Any other ideas

[Sainath.Srinivasan]

Can you provide
a.) The code of the routine
b.) The step by which you called it
c.) Values passed
d.) Value returned
e.) Reason what makes you think it is wrong

[ArndW]

snassimr,

as Sainath and others have stated, the source of this routine would be nice as it seems to be the only place, from what you've described, where something might be working differently between your two different types of run.

[ketfos]

Hi,
What are the values of following parameters you are using in your job?

TempDateN

TodayDateN

Thanks

Ketfos

[ray.wurlod]

The computer is incapable of doing anything but exactly what you tell it to do. Therefore, what you have coded is not what you expected to code. That is the main reason we need to see the code of the routine.

Based on your description, it appears that the code is selecting the lesser of the two dates, which is 20010101 (or 2001-01-01). If this is not what you expect, then your algorithm needs refinement.

Can you also post your algorithm design (the document you created before writing the routine)?

[chulett]

Hmmm... document design before coding... have to write that one down.