A String-type variable could not be parsed as a date, time, or time zone.

KNIME Analytics Platform
1

Hi all,

I’m trying to pass a variable to a Date&Time-based Row Filter node, and have formatted the String-type variable as ''yyyy-MM-dd HH:mm:ss"; however, when I select this variable as start-date-time in the Date&Time-based Row Filter node, it gives me an error, saying ‘2019-02-01 00:00:00’ could not be parsed as a date, time, or time zone.

I’ve tried variable datetime formats including/excluding timezone, but non works.

I know that Data&Time can be a bit tricky, any clue what kinda format can be accept as a valid datetime variable in Date&Time-based Row Filter

Thanks,
Olivia

3

Hi,

You have to use this format:
2019-02-01T00:00

Best,
Armin

P.S. Use the same format as your data format. You can use date, time or date&time formats in the variable to feed the Date&Time-based Row Filter node. Just check your dataset for the format and use the same one for your variable.

1 Like
4

Thanks @armingrudd

Just changed the string format as per you suggested and my column to filter is of Local Date Time type, and it works good now :slight_smile:

2 Likes