Skip to main content
Question

Date User Parameter becomes a varchar with different format

  • June 25, 2026
  • 6 replies
  • 96 views

s.jager
Influencer
Forum|alt.badge.img+26

In a process that deals with GPS messages that are received every 15 minutes, I have two User Parameters that set a Start- and an End date, in order to prevent having to process a couple of million rows from the database every time. These are configured as DateTime parameters, with the Datetime Format set to Date only.

The GPS Fix time is copied to a new attribute while converting to a Date, using a DateTimeConvertor. Format selected is FME date (%Y%m%d). If I then use a Tester to check whether the GPS fix time falls between the start- and end date (with Comparison Mode set to Date/Time), they all fail, because the parameters value is 2026-01-01, while the attributes value is 20260101. So the Tester’s comparison

Date >= $(StartDate)

(where Date is the by DateTimeConvertor created attribute) does not work anymore, since our upgrade to 2026.1.2. Before (when we used 2025.0.3) this was working without a problem. Upgrading the DateTimeConvertor and the Tester (this is an older workspace) did not make a difference.

It’s fixable, that’s not the problem - but it is a bit unexpected. Anyone else ran into this? It’s little things (bugs?) like this that make upgrading such a pain. I only noticed this one because all of a sudden no more Geopackage appeared, which made me investigate, discovering that FME said that all data fell outside of the selected dates...

6 replies

j.botterill
Evangelist
Forum|alt.badge.img+61
  • Evangelist
  • June 25, 2026

In 2026.1, Safe seems to have tightened the date parsing

I recently posted about Is function DateTimeNow() in >2026 no longer supported.... in favour of CurrentDateTime? ISO_8601 durations | Community where I can’t work out the date type user paramaters

Another unexpected datetime issue I’ve encountered, is upgrading DateTimeStamper now enforces a default ISO output. Most of my downstream processing to these highly used transformer… expected it as FME date output… so I have alot of broken workspaces should I upgrade transformers

bulk transformer upgrades default to ISO, no user choice unless single transformer upgrade

 


s.jager
Influencer
Forum|alt.badge.img+26
  • Author
  • Influencer
  • June 25, 2026

Another unexpected datetime issue I’ve encountered, is upgrading DateTimeStamper now enforces a default ISO output. Most of my downstream processing to these highly used transformer… expected it as FME date output… so I have alot of broken workspaces should I upgrade transformers

Now that you mentioned it: I’ve ran into that one as well. I write out logfiles quite a lot (for keeping track of changes made by nightly processes) and I always use a DateTimeStamper with the date to Fanout my logfiles to yyyymmdd_<logfile_name>. That suddenly got messed up indeed…

But you’d think that something like that would then be enforced everywhere, and apparently it isn’t.


donalmateer
Safer
Forum|alt.badge.img+11

@s.jager 

FME 2026.1 moved to ISO 8601 datetimes across the board, so new Date Only user parameters now store as 2026-01-01 instead of the old FME format 20260101. It's logged under FMEFORM-13030. The DateTimeStamper surprise you and j.botterill both hit ties back to a related open item, FMEFORM-37767, about bulk transformer upgrades silently defaulting to the new format.

That said, by our own records existing parameters in existing workspaces shouldn't change format unless the parameter itself is recreated, so what you're seeing, on an older workspace with no parameter recreation, looks like it may be going further than intended. That's worth us digging into rather than just filing under "expected."

Possible fix/workaround: add a DateTimeConverter right after you reference the parameter, to force it back to FME format so it matches your existing DateTimeConverter attribute. That should get your Tester comparison working again without touching anything else.

One thing that would help us dig further: did you resave the workspace itself in 2026.1.2, separate from upgrading the DateTimeConverter and Tester individually? If not, I'd like to look into this more, feel free to open a support ticket with your build number so we can check.

Thanks for flagging it, let us know how it goes!


s.jager
Influencer
Forum|alt.badge.img+26
  • Author
  • Influencer
  • July 27, 2026

FME 2026.1 moved to ISO 8601 datetimes across the board, so new Date Only user parameters now store as 2026-01-01 instead of the old FME format 20260101. It's logged under FMEFORM-13030.

OK. Not sure if I’m happy with that, since I now always have to change the setting from ISO to FME, but that is what it is. I basically never use ISO formatted dates or datetimes, unless it’s specifically required by whatever format I’m writing to - and then I won’t change it until right before writing the data out. And especially for fanning out the FME format for dates is extremely useful. 

 

​One thing that would help us dig further: did you resave the workspace itself in 2026.1.2, separate from upgrading the DateTimeConverter and Tester individually? If not, I'd like to look into this more, feel free to open a support ticket with your build number so we can check.

I do not remember, and it is too long ago that I would be able to check. All I remember is that it suddenly did not work anymore as expected, but I’m not using a versioning system - so I have no way of going back a month or more to see what the exact changes were that I made when I discovered it. Since upgrading usually requires a lot of intensive testing (to avoid surprises like this!), I usually try to avoid it as much as I can - but that does not mean that I didn’t copy and paste the setup from an old workspace into a new one for example.

 


j.botterill
Evangelist
Forum|alt.badge.img+61
  • Evangelist
  • July 27, 2026

s.jager
Influencer
Forum|alt.badge.img+26
  • Author
  • Influencer
  • July 27, 2026

Good question. Must’ve missed it earlier, but I wholeheartedly agree.