Check Date-Timestamp in Mapping

Hi,

I have a source message like:

<CustomerData>
<CustomerName>XYZCorp</CustomerName>
<Date>20110302153055</Date>
</CustomerData>

I need to validate the format of the Date field in mapping for:

1) Date format should be YYYYMMDD

2) Time format should be HHMMSS

3) The Date should be future Date (any valid date greater than current date).

If validation is success then Target NodeA should be created. If validation fails then target NodeB should be created.

How should this be coded in mapping? I assume that UDF would be required but which one?

Thanks

Pankaj.

Edited by: Pankaj Sharma XI on Mar 2, 2011 11:26 AM