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
+25
- Influencer
- 3345 replies
-
31 January 2023
Which attribute are you converting? What does the input look like?
Which attribute are you converting? What does the input look like?
Sample table above, suing the transformer to convert into the format on the right
+21
- Contributor
- 3079 replies
-
2 February 2023
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
+25
- Influencer
- 3345 replies
-
2 February 2023
Sample 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.
+2
- Contributor
- 3 replies
-
8 April 2024
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)
+10
- Safer
- 371 replies
-
13 April 2024
Hi
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.