Unparseable date: "" error in pi

[Former Member]

Hi Experts,

Can anyone please help me for the below query

On the receiver side I need to get value as ' 2010-12-30TO8.00:00 '.

To achive this in graphical mapping i used date trans but i am geting error as unparseable date..

Regards

Akhil

[baskar_gopalakrishnan2]

I believe you are giving your date/Time separator as 'T' in the output date format. Otherwise you will sure get parsing error.

Declare the data type as string only. You should be okay.

[Former Member]

Hi

I have faced the same problem. It would not work with date trans.

Assuming you have separate date time field on the source side.

Date (Trim)

-

---

Concat (T)--

---

trim--Target

Time(Trim)

Regards

Monika

[Former Member]

Hi,

try source date format as YYYY-MM-DD'TO'HH:MM:SS for your example' 2010-12-30TO8.00:00 '

Regards,

Suresh

[Former Member]

The error is bcoz. for the Target field you need to give data type as DateTime and not Date as you are expecting Date and Time

[Former Member]

Hi,

This error Usually Comes .,. when Ur Transform(Date Function) is expecting Date in Some Specific format and your are Providing Input Date in some Other format .

So Please Check , what is the format of Actual Coming Date and then Double Click on DateTransform Function and Match the format of source Date Format.

if both Not same , make both format same,

INPUT DATE - TRANSFORM DATE FUNCTION - OUTPUT DATE

TRANSFORM DATE Has 2 values ( Source Date and Target Date)

So INPUT date format and Source date format of DateTrans Function should match.

similarly

So OUTPUT date format and target date format of DateTrans Function should match.

Regards

Prabhat Sharma.

[baskar_gopalakrishnan2]

>> I need to get value as ' 2010-12-30TO8.00:00 '.

Use DateTrans function carefully...

open date format window follow this direction

output date format as

Date format yyyyMMdd

Time HHmmss

Date Seperator -

Time Seperator :

Date/Time Seperator T

Note: Input date format as you receive from the sender side.

Hope this helps.

Baskar

[Former Member]

Hi svraju,

While doing graphical mapping, in date trans function you will specify the formats for input date and output date. so make sure that the input date format which you have maintained in the date trans is same when compared to the input date coming from the sender.

when the format do not match, the PI throws the error Unparseable date

Thanks,

Lalitkumar.

[former_member200962]

provide the input and output date formats that you have provided in the mapping

2010-12-30TO8.00:00

is it TO (to in caps) or should it be T0?

8.00:00 .... you need to maintain only one time separator....8:00:00 (HH:MM:SS)

Your above format (according to me) should be Date - YYYYMMDD....Time - HHMMSS

Date separator should be - ....Time separator : ....Date Time separator T

Also the source date should be as per the format mentioned in input date format.

Regards,

Abhishek.

Edited by: abhishek salvi on Jan 5, 2011 12:27 PM

[Former Member]

Hi,

This error could be due two reasons:

1. A valid date in the correct format was not passed

2. An empty string was passed instead of a valid date format.

To know the exact issue, please give the below details:

1.Source date format and receiver date format

2. How are you converting the date from source format to target format

3. What is the value you are passing from the source

Thank you.

Regards,

Subbu

[markangelo_dihiansan]

Hello,

This is because you are not passing any value in your dateTrans function. Try passing a valid date

Hope this helps,

Mark