Skip to main content
Solved

IFS Connect Floe Stops upon Package Modification

  • Mar 30, 2022 5:57 AM UTC
  • 2 replies
  • 62 views

waidyah
Do Gooder (Partner)
Forum|alt.badge.img+7

The above code modification compiles and is technically correct but my IFS Connect flow doesn’t run thereafter.

Commenting out this inclusion will make it work again.

Best answer by Charana Udugama

Hi @waidyah,

I think the usage of ‘TO_DATE’ is wrong. The correct usage should be the other way around. Can you try by interchanging date and the format? see below,

TO_DATE(‘31/12/…….’, ‘DD/MM/YYYY)

This might solve the issue. Comment further if you need further clarifications.

Best Regards,
Charana

View original

2 replies

Charana Udugama
Superhero (Employee)
Forum|alt.badge.img+12
  • Superhero (Employee)
  • Answer
  • Mar 30, 2022 10:29 AM UTC

Hi @waidyah,

I think the usage of ‘TO_DATE’ is wrong. The correct usage should be the other way around. Can you try by interchanging date and the format? see below,

TO_DATE(‘31/12/…….’, ‘DD/MM/YYYY)

This might solve the issue. Comment further if you need further clarifications.

Best Regards,
Charana


waidyah
Do Gooder (Partner)
Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • Mar 30, 2022 3:51 PM UTC

…

Hi Charana,

Thanks a lot for the inquisitive eye - you saved days of work perhaps.