Invalid Date issue bug

clarcombe · Post by **clarcombe** » Wed Nov 19, 2008 4:33 am

I have a date in the format YYYYMMDD which is tested by the following routine (stolen from Ray's IsValid)

Test1 = Iconv(fieldval, "DYMD[4,2,2]")
Status1 = Status()

When I pass the value 20080931, this passes as valid which is incorrect as September only has 30 days.

When I pass 20080932 this is correctly handled and fails

Bar hardcoding month checks i.e. writing my own routine, is there any other internal function that can be used ?

Romy · Post by **Romy** » Wed Nov 19, 2008 5:28 am

Hi,

In the DS Manager there is in build transform to check whether the input date is valid one or not.

Go to Transforms--> SDK-->Date-->Generic. In this you have transform name "DateGenericIsDate". Using this you can check whether the input date is recognised as valid or not. Returns 1 if a good date, 0 if a bad or unrecognised date.

Try this.

clarcombe · Post by **clarcombe** » Wed Nov 19, 2008 7:24 am

Thanks for the suggestion.

I have tried calling this in a routine with the following [not all of the routine is shown below]

Code: Select all

      DEFFUN DateGenericToTimeStamp(InputDate) calling "DSU.DateGenericToTimeStamp"

               Status1 = DateGenericToTimeStamp(fieldval)
               Call DSLogInfo (Status1 ,"ValidLigne")

But I get the following error in Director

Code: Select all

Program "DSU.ValidLigne": Line 88, Unable to open the operating system file "DSU_BP.O/DSU.DateGenericToTimeStamp".
[ENOENT] No such file or directory
Program "DSU.ValidLigne": Line 88, Unable to load file "DSU.DateGenericToTimeStamp".
Program "DSU.ValidLigne": Line 88, Unable to load subroutine.
Attempting to Cleanup after ABORT raised in stage BI1_200_ENT016.PSN_BI_EXCEL___000033_000_BI1_200_ENT016.LectureDonneeDataStage Phantom Aborting with @ABORT.CODE = 3

Can a SDK transform be used in a routine. If not, how can I access it ?

chulett · Post by **chulett** » Wed Nov 19, 2008 8:22 am

No, transforms of any kind cannot be used in routines. You need to include their equivalent code into the routine itself.

clarcombe · Post by **clarcombe** » Wed Nov 19, 2008 8:25 am

Any ideas how to get at the code ?

Does the fact that it is in sdk\Date\Generic mean that I can't access it ? I can't seem to find anyway to look at the code

chulett · Post by **chulett** » Wed Nov 19, 2008 8:32 am

There is no "code" per se with a transform as they are an interlude to existing routines. Everything they are is in the "Definition" prompt of the Details tab and that's what you'd need to include.

clarcombe · Post by **clarcombe** » Thu Nov 20, 2008 2:28 am

Thats the problem

The definition is DateGenericToTimeStamp(%InputDate%, 0). When I try to include this in my routine it fails with the error mentioned previously.

I have added hardcode which checks the number of days according to the month specified. I haven't included leapyears but too bad.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 20, 2008 3:41 am

Hang on a minute. The DSU. prefix indicates that it's a Routine - you should be able to see it in your Repository. However the message suggests that it's not there. Can you see it in another project? If so you can export it from there (if read-only object export is enabled) and import it into the project from which it's missing.

chulett · Post by **chulett** » Thu Nov 20, 2008 8:54 am

Looks to me that the "DateGenericToTimestamp" routine may not be compiled, as what cannot be found is "DSU_BP.O/DSU.DateGenericToTimeStamp".