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.
Date validation
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 68
- Joined: Sat Feb 05, 2005 4:59 am
- Location: India
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: