Solved

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

Forum|Forum|2 years ago
February 23, 2023
5 replies
28 views

G

geo.uqam
2 replies

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

Best answer by david_r

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

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.