Skip to main content
Question

Problem with Date fielf in Open API Writer (Fgdb()


fme_dr22_forum
Contributor
Forum|alt.badge.img+4
I have a problem writing a date field in a Filegeodatabase (open API Fgdb Writer)As soon as I enter these date fields manually, nothing is put in the Fgdb.In the attribute creator I enter @DateTimeFormat(20240101,%d-%m-%Y) so this should work.What can I do to make this work?

5 replies

hkingsbury
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • February 15, 2024

That should work. I wonder if there is something else going wrong. Are there any warnings or errors in the Translation Log?


fme_dr22_forum
Contributor
Forum|alt.badge.img+4

Hello hkingsbury, 

Thank you for your reaction. No, FME does not give any error messages. Or could it be that the time/date of our system is not set correctly? I live in the Netherlands. Time zone on our system is (UTC+1:00)
I have set the attribute creator like this (date field: beginGeldigheid)

 


hkingsbury
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • February 18, 2024

What version of FME are you using? It’s working fine for me in 2023.1

See an attached example


fme_dr22_forum
Contributor
Forum|alt.badge.img+4
We are using version FME 2022.2.6.0 (20230523 - Build 22800).Seems to be a little older than the version you have.I haven't been working with FME for long. How can I open the attached example? I now get the following and I don't know how to link the creator to my dataset.

 


hkingsbury
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • February 19, 2024

Not to worry, ignore that attachment. Can you try removing the DateTimeFormat function and running it again with the value ‘20240101’ (in your original workspace, not the one I posted)



Slight tangent explaining the screenshot

Transformers have versions, and between workbench/form versions, these will sometimes get updated. You would’ve got some sort of warning about opening a newer workbench in an older version of FME. There should be an attribute creator in between the creator and writer. This indicates that the version of the creator and the writer is the same in 2022.2 and 2023.1 but the attribute creator has been updated between those versions, so the older version can’t find it

 

 

 


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