Skip to main content
Question

DateFormatter only outputs current date or default value

  • October 3, 2017
  • 6 replies
  • 22 views
I
Forum|alt.badge.img

I am trying to format a source attribute that stores a date value as a single 4-character long year value (1995, 2000, 2005) to be in ISO date format (1995-01-01). However my DateFormatter transformer is only outputting values for the current date or for the default value when it encounters an invalid value (0001-01-01).

Any ideas? I'm lost. See below for pictures describing the problem.

Workbench & DateFormatter transformer

Original dates before being transformed

(The "YEAR" attribute is renamed to "utility_year_of_construction" in between here)

Dates after being transformed

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

6 replies

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • October 3, 2017
The pictures aren't showing...
I
Forum|alt.badge.img
  • iboates
  • Author
  • 9 replies
  • October 3, 2017
The pictures aren't showing...
I was able to copy and paste them into the submission box so I thought they could get uploaded automatically, but they didn't. I just hosted them on imgur and updated the post.

 

 

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • October 3, 2017

How about just using an AttributeCreator rather than the DateFormatter:

redgeographics
Celebrity
Forum|alt.badge.img+60
  • redgeographicsCelebrity
  • Celebrity
  • 3704 replies
  • October 3, 2017

Didn't see any pictures, could you post them just to make sure I'm answering the right question :)

FME rocks! \m/
I
Forum|alt.badge.img
  • iboates
  • Author
  • 9 replies
  • October 3, 2017

How about just using an AttributeCreator rather than the DateFormatter:

This seems to have fixed it but this is strange behaviour for the DateFormatter.

 

 

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • October 3, 2017
This seems to have fixed it but this is strange behaviour for the DateFormatter.

 

 

It would help if we could see the pictures...

Community Stats

32,093
Posts
121,875
Replies
39,731
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.