input is 10 digit date (dd/mm/yyyy) some times instead of date they will se

[Former Member]

Hi Experts,

requirement is

input is 10 digit date (dd/mm/yyyy) some times instead of date they will send as space(10 digit). it should not fail in PI.

kindly help me on this.

regards

Elton

[Former Member · Accepted solution]

Use if else mapping.

If Field is Blank(Costant and 10 space) Then pass the same to target side

Or

Use the Date Trans function and convert the date

[Shabarish_Nair]

the standard datetrans function will not help you to handle exceptions hence as suggested by others, do the validation earlier before passing the value to datetrans or using direct mapping.

[Former Member]

HI,

input is 10 digit date (dd/mm/yyyy) some times instead of date they will send as space(10 digit). it should not fail in PI.

input -> constant(10 space) -> equals ->if ->

then -> constant(date) ->target ( in taget side date is mandatary then pass constant value)

else -> input->target filed

thanks,

[Former Member]

I have given like

if input equals to constant(space)

then constant(space)

else

input

eventhough it is failing.

regard elton

[Former Member]

HI,

I have given like

if input equals to constant(space)

then constant(space)----

---

> here you have to pass constant date / system date

else

input

input -> constant(10 space) -> equals ->if ->

then -> constant(date) ->target

else -> input->target filed

thanks,

[Former Member]

thank experts. it is working fine.

[Former Member]

Hi,

You need to handle that externally.

If date.equals("          ") ----> Constant("") ---> Data(PI)
Esle
use the currently mapping!

Regards

Ramesh