Question

Formatting a date

Forum|Forum|12 years ago
September 5, 2013
2 replies
61 views

+1

seanob
Contributor

Hi,

I'm transforming data from a MS Excel spreadsheet into Google KMZ. I've encountered a problem with formatting whereby a date like 05/09/2013 in Excel is ending up as 20130905000000.000 in Google. I've tried using the DateFormatter transformer but without success as I'm not entirely sure how to apply it. Can anyone help? These should UK dates.

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.

david_r
Forum|Forum|12 years ago
September 5, 2013

Hi,

if you're not using the latest version of FME (2013 SP2), you will probably have better results using the DateConverter transformer available on the FME Store.

Using this transformer you should also specify the input date format.

David