+15I have an AttributeCreator that is meant to create a new attribute called "regDate" with the value:
@DateTimeParse(@Value(supByRegPlanDate), %Es)
The output for regDate is the string: @DateTimeParse(1543293100000, %Es)
However, I am expecting an output similar to: 20181127043140
Any suggestions why the output is showing the expression that had obtained the value from the feature, but, not created a DateTime?
+22Did you use the TextEditor?
You will probably need to use the Mathematical Editor.
Hope this helps.
+44Your input time is not in seconds but in milliseconds, convert to seconds before parsing. You cannot use the arithmetic editor for datetime expressions (but you will to convert to seconds!) I think you have to separate it into two statements e.g.
+37Use the following expression @DateTimeParse(@Evaluate(@Value(supByRegPlanDate)/1000),%Es)
+15Your input time is not in seconds but in milliseconds, convert to seconds before parsing. You cannot use the arithmetic editor for datetime expressions (but you will to convert to seconds!) I think you have to separate it into two statements e.g.
Hello egomm,
I am unable to view your example.
Phil
+15Did you use the TextEditor?
You will probably need to use the Mathematical Editor.
Hope this helps.
I did use the String Editor, when I change to the Arithmetic Editor i get the output of <null>.
+15Use the following expression @DateTimeParse(@Evaluate(@Value(supByRegPlanDate)/1000),%Es)
That expression give the output of: @DateTimeParse(1543293100, %Es)
Previously I had the output of: @DateTimeParse(1543293100000, %Es)
I am still not getting the @DateTimeParse expression to evaluate.
+15How do I test whether my version of FME has a licence or access to use the @DateTimeParse function?
+15Your input time is not in seconds but in milliseconds, convert to seconds before parsing. You cannot use the arithmetic editor for datetime expressions (but you will to convert to seconds!) I think you have to separate it into two statements e.g.
It did need to be two separate statements, thank you.
+37That expression give the output of: @DateTimeParse(1543293100, %Es)
Previously I had the output of: @DateTimeParse(1543293100000, %Es)
I am still not getting the @DateTimeParse expression to evaluate.
What version of FME are you using? It's working for me.
+15What version of FME are you using? It's working for me.
I am using FME 2016.1
+16Is this what you're looking for @DateTimeParse(@Evaluate(@div(@Value(supByRegPlanDate),1000)),%Es)
+37I am using FME 2016.1
I don't have that version anymore, it does work in 2017 and 2018.1 though.
I'm curious, in the attributeCreator if you just entered @Evaluate(@Value(supByRegPlanDate)/1000) do you get 1543293100 or the expression as text?
Likewise of you entered @DateTimeParse(1543293100, %Es) does it give you the correct formatting or the expression again?
