Hi @aburns, how about this?

1. DateFormatter (1): Convert the datetime string to the number of seconds elapsed from the epoch  (Destination Date Format: %s).
2. ExpressionEvaluator or AttributeCreator: Divide the value by 300 seconds (= 5 minutes), truncate decimal places, and multiply by 300.
3. DateFormatter (2): Restore the original datetime format (%Y-%m-%d %H:%M:%S).

Assuming that the time value converted by the first DateFormatter is stored by an attribute called 'time', the expression is:

@int(@Value(time)/300)*300

Here's one possible solution using string manipulation and lists:

@int(@Value(time)/300)*300

Always fun to see how differently you can do things in FME and still get the same results :-)

Yeees, me too There is more than one way almost always. The StringReplacer can be used to replace the last four characters appropriately.

• Text To Match: (....)$
• Replacement Text: <0:00 or 5:00 according to the number of fourth from last>
• Use Regular Expressions: yes

Hi

Thanks for the replies. I am still experiencing issue:

Any ideas where im going wrong?

Thanks

Maybe try setting source date format to "%s" in the last DateFormatter? FME is not very good at guessing date formats, in my experience...

@aburns, you have to specify the Source Date Format parameter in the second DateFormatter. Try setting '%s' there. See also the help doc on the DateFormatter to learn more about date/time formats

@takashi, @david_r

Spot on, missed that! Sorted that out nicely!

thanks both, appreciated all the replied as we can all see we can get to the same endpoint using different method. I didnt even think of the string replacer and regex.

Regards

Andy

@int(@Value(time)/300)*300

This works nicely and very easy.