Filter data in ODBC

[Loeckli]

Hello Everybody 🙂

My question is about filtering the data. I would like to filter my table DATE_STARTED beforehand.
The dates have the following format DD.MM.YYYY HH:MM:SS.
My goal is to load only the data from the year 2022.
I have already typed in the following staments without success.

DATE_STARTED = 2022

DATE_STARTED = Year(2022)

[JordyWegman]

Hi Loeckli,

You should convert the date or adjust your parameter.

Year( DATE_STARTED ) = 2022

or

DATE_STARTED >= Timestamp#( ‘01-01-2022 00:00:00’  , ‘DD-MM-YYYY hh:mm:ss’ )

Jordy

Climber