I have an attribute in a .gdb containing dates in the format (yyyy) in a geodatabase in short integer which I need to change to an actual date attribute in the format (dd-mm-yyyy) with the date being january 1st for all. Is this possible? /Rasm
+1Best answer by ebygomm
If you are writing back to a date field then you just need to create the dates in FME format (YYYYMMDD). So just append 0101 to the year and then write back to a date field. If you are writing to another format then you can append 0101 and then use a DateTimeConverter to get the desired format
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.
+44- Influencer
- 3427 replies
- Best Answer
If you are writing back to a date field then you just need to create the dates in FME format (YYYYMMDD). So just append 0101 to the year and then write back to a date field. If you are writing to another format then you can append 0101 and then use a DateTimeConverter to get the desired format
+1Hi, thank you very much for the response and sorry for the slow answer. I only had a chance to test it now.
Okay so now i am writing back into the date field with dates in the FME format (YYYYMMDD). When I try to run the workbench I get a fatal error saying: "An error occurred while attempting to convert the '' component of a date".
It is not clear to me if I should change it back into the format used in the GDB (DD-MM-YYYY) before writing it back to the GDB, so that i first create the dates, write them back into the date field in FME format, and then lastly change them back to gdb format before writing into the gdb.
I have tried both running with and without changing it back to the format used in the gdb but i get the same error.
+44- Influencer
- 3427 replies
Hi, thank you very much for the response and sorry for the slow answer. I only had a chance to test it now.
Okay so now i am writing back into the date field with dates in the FME format (YYYYMMDD). When I try to run the workbench I get a fatal error saying: "An error occurred while attempting to convert the '' component of a date".
It is not clear to me if I should change it back into the format used in the GDB (DD-MM-YYYY) before writing it back to the GDB, so that i first create the dates, write them back into the date field in FME format, and then lastly change them back to gdb format before writing into the gdb.
I have tried both running with and without changing it back to the format used in the gdb but i get the same error.
Double check the value you are sending, you should be able to send a date in FME format
20210101 (8 digits)
or a date time
20210101000000 (14 digits)
and the writer will handle both those formats.
I can generate that error message if I send it, for example 9 digits (202101011) or 7 digits (2020011)
It will error if you attempt to send it a formatted date as in DD-MM-YYYY
+1This solved it for me. A few rows had not been given a year and therefore had the wrong format.
Thanks!