Skip to main content
Question

Am using DateTimeConverter to change date YYYYMMDD into YYYY-MM-DD (CSV File), it is converting it when check on Visual Preview. But when open in excel, does not show it. Seeing FME_Rejection_Code = Invalid Input


Am using DateTimeConverter to change date YYYYMMDD into YYYY-MM-DD (CSV File), it is converting it when check on Visual Preview. But when open in excel, does not show it. Seeing FME_Rejection_Code = Invalid Input

10 replies

  • Author
  • January 30, 2023

Screenshot 2023-01-30 135610


redgeographics
Celebrity
Forum|alt.badge.img+47

Which attribute are you converting? What does the input look like?


  • Author
  • February 1, 2023
redgeographics wrote:

Which attribute are you converting? What does the input look like?

imageSample table above, suing the transformer to convert into the format on the right


ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • February 2, 2023
tiki13457 wrote:

Screenshot 2023-01-30 135610

If you look at your screenshot, everything is exiting the DateTimeConverter from the Rejected Port.

Can you share your settings, it's not doing what you want it to do.

 

If you have null values in your data, you need to make sure Passthrough nulls, empties or missing is set to Yes


redgeographics
Celebrity
Forum|alt.badge.img+47
tiki13457 wrote:

imageSample table above, suing the transformer to convert into the format on the right

And, as @ebygomm​ said, how have you set up your DateTimeConverter? The input looks like it can be autodetected and the output isn't too tricky either. %Y%m%d as input and ISO date as output should work.


badgerseatfrog1
Contributor
Forum|alt.badge.img+2

I am going to jump aboard this community post with my screenshot of a similar issue.

I can’t work out why this simple example is getting rejected. I want to read in the date value %d%m%Y and convert it to another date format (in the example above I have used %Y for simplicity/testing).
The Preview Data within the transformer behaves as expected but the transformer rejects it.

Version: FME(R) 2023.1.0.0 (20230825 - Build 23619 - WIN64)

 


nampreetatsafe
Safer
Forum|alt.badge.img+12

Hi @badgerseatfrog1:   I’m sorry you’ve come across an issue with the DateTimeConverter.  I was able to reproduce this issue. I’ve created a ticket for our development team to look at (internal reference FMEENGINE-82492).  We’ll keep you posted on any updates here.


chelseawu
Contributor
Forum|alt.badge.img+13
  • Contributor
  • February 4, 2025

Wondering if this issue has been resolved.

I have a similar issue with DateTimeConverter. I can’t convert ‘path_modifed_date’ or ‘_timestamp’ field. I have only one record, this does not make sense.

I am using FME workbench v 2024.2


DanAtSafe
Safer
Forum|alt.badge.img+16
  • Safer
  • February 5, 2025

Hi ​@chelseawu Yes, this was fixed via FMEFORM-13351.  Make sure that the Datetime Attributes is e.g.

path_modified_date

and not

@Value(path_modified_date)


chelseawu
Contributor
Forum|alt.badge.img+13
  • Contributor
  • February 5, 2025
DanAtSafe wrote:

Hi ​@chelseawu Yes, this was fixed via FMEFORM-13351.  Make sure that the Datetime Attributes is e.g.

path_modified_date

and not

@Value(path_modified_date)

 

Yes, this works! Thank you very much! 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings