Date validation

adarsh shrinagesh · Post by **adarsh shrinagesh** » Mon Dec 05, 2005 5:24 am

Hi

As part of our Error Handling logic we need to check
>whether a given date valid or not
Ex - 2/2/1999 - Valid
2-02-2000 - Valid
>whether a given timestamp is valid or not

the Date conversion functions in the Parallel Transformer/Modifier need explicit specification of the delimiter and format string
This does not allow single digit months and days

Have tried using the IsValid Function as well to no avail

Are there any workarounds?

The source field is of type Varchar and extracting the individual field for padding etc does not seem clean.

ArndW · Post by **ArndW** » Mon Dec 05, 2005 5:37 am

I recently had to go through the same type of issues with dates, the format needs to be explicit in PX - a %yyyy-%mm-%dd format will error on a "2005-1-1" date! There is no direct and easy workaround for this in PX; you will need to cater for these types of formats yourself. Or think about using a slow BASIC transform stage or coding your own c++ routine to take care of this if high speed is required.

pavankvk · Post by **pavankvk** » Mon Dec 05, 2005 4:22 pm

what we did is..

if u know the format of date like if it comes in 12/5/2005 we use to parse it and then build 12-05-2005 and then use the existing functions.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 05, 2005 7:50 pm

Can you please provide details of how you do this in parallel jobs?