Recent content by JYK

Oh this works as well!

My mistake. I tried again, found this works. SELECT * FROM my_table where mycolumn is not null and "2020-08-24 23:07:07" < mycolumn the correct way to compare string type of datetime in access is this THANK YOU!!

I'm super newbie 😿

SELECT * FROM my_table where mycolumn is not null and mycolumn <> '' and CDate("2019-05-24 23:07:07")<CDate(mycolumn) This failed but this works SELECT * FROM my_table where CDATE("2020-08-24 23:07:07") < CDATE(NZ(IFF(mycolumn = '', NULL, mycolumn), "2000-01-01 00:00:00")) Thank you :)

Nope I'm using both MS Access application (SQL View) and C# OLEDB Access Driver. I checked the type of mycolumn using C# connection GetSchema() function

I'd tried it as string but the output was not what I expected 😭

Thank you for reply. I tried it but still throws error. every thing ok when I run like select cdate("2022-05-24 23:07:07"); or select cdate('2022-05-24 23:07:07'); select cdate("2022-05-24 23:07:07"); or even SELECT CDate("2022-05-24 23:07:07")<CDate(Nz(mycolumn,"2000-01-01 00:00:00")) FROM...

sorry my mistake. I updated the post please refresh page

Hi there I can not fix this error for about 2 hours. What am I doing wrong? when I query like below, I get 'Data type mismatch in criteria expression' or 'invalid use of null'. The message changes when I change where clause. or mycolumn is varchar type and has null values. and data format is...