Skip to main content
Question

Problem with @DateTimeCreate function

  • November 8, 2018
  • 4 replies
  • 62 views
V
Forum|alt.badge.img+1

I get the following message which I do not understand.

fme_expression_warnings{0}.message (string): Failed to evaluate expression '@DateTimeCreate(2018,11,5,6,9,14,0)'. Result is set to null

I tried filling the values as string values and converted to @int() and get the same result. Also tried with -0 as the last value.

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.

4 replies

takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • November 8, 2018

Check the warning shown in the log.

The syntax of a UTC offset must be (+|-)hh:mm, (+|-)hhmm, or (+|-)hh

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • November 8, 2018

Check the warning shown in the log.

The syntax of a UTC offset must be (+|-)hh:mm, (+|-)hhmm, or (+|-)hh

See also here to learn more: Date/Time Functions

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
mark2atsafe
Safer
Forum|alt.badge.img+56
  • mark2atsafeSafer
  • Safer
  • 2554 replies
  • November 8, 2018

Like Takashi says, this should work:

@DateTimeCreate(2018,11,5,6,9,14,+0000)

Use an AttributePadder to pad to four zeros and the StringConcatenator (or AttributeManager) to add the + symbol
FME Evangelist to the Rich and Famous!!
V
Forum|alt.badge.img+1

Thank you both. Two zeros already works.

Community Stats

32,084
Posts
121,834
Replies
39,720
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.