Skip to main content
Question

Problem with @DateTimeCreate function


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.

4 replies

takashi
Influencer
  • November 8, 2018

Check the warning shown in the log.

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


takashi
Influencer
  • November 8, 2018
takashi wrote:

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


mark2atsafe
Safer
Forum|alt.badge.img+44
  • Safer
  • 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

Forum|alt.badge.img+1

Thank you both. Two zeros already works.


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