Filter records by date string

[madpiet]

Okay, what am I missing? I set up a really simple table with a text column and a date column. (Oh, and then a simple form based on that). I can enter the date as 2025.10.1, and it works fine. or just 2025.10 converts to 2025/10/1

[madpiet]

What's the Czech date format? yyyy.mm.dd?

[Welshgasman]

What's the Czech date format? yyyy.mm.dd?

Looks to be dd.mm.yyyy ?

[madpiet]

Looks to be dd.mm.yyyy ?

I was thinking use SPLIT() to break the date string into chunks and then use CAST and DATESERIAL to convert it to a real date... Not sure how else to do it.

[Welshgasman]

I was thinking use SPLIT() to break the date string into chunks and then use CAST and DATESERIAL to convert it to a real date... Not sure how else to do it.

That is the problem. the O/P does not want to enter a full date, just part of a date.

[madpiet]

but then couldn't you just test the parts of the string for null and substitute 1? (Well for the day, anyway)