Filter by date value - Select date value starting with "2023", "2022", etc.

In SQL, it's possible to select all your data starting with "2023" like this :

-------------------------------------

SELECT *

FROM mydata

WHERE date LIKE "2023%"

--------------------------------------

Is there a way to do it with FME?

I have already apply a "DateTimeConverter" to convert my data in FME format (20230223).

I see on FME Workbanch that there is a "SQLCreator", but I need to import my data from a url and not from an DataBase like PostGIS

Page 1 / 1

The easiest is probably to use a Tester with a criteria to check for "starts with".

You can use the Transformer Tester.

In the configuration of Tester, has a option Begin With.

Thanks in Advance,

The easiest is probably to use a Tester with a criteria to check for "starts with".

It works! Thank you, it is appreciated.

The easiest is probably to use a Tester with a criteria to check for "starts with".

Same time :)

That was my very first question. Now I know that there is a very active community ready to help. Thank you!😀

Sign up