+12I 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?
+18Did you use the TextEditor?
You will probably need to use the Mathematical Editor.
Hope this helps.
+38Your 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.
+28Use the following expression @DateTimeParse(@Evaluate(@Value(supByRegPlanDate)/1000),%Es)
+12Your 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
+12Did 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>.
+12Use 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.
+12How do I test whether my version of FME has a licence or access to use the @DateTimeParse function?
+12Your 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.
+28That 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.
+12What 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)
+28I 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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
