Can some explain this in dates?

[CJ_London]

it may look the same, but the function is returning a string, not a date

with regards attachments this is what I see


perhaps you didn't click the upload file

It accepted it (in a table entry) without a problem.

No problem because it ignores it and leaves it as null

for your criteria, try

cDate(fDt(....)

[twgonder]

I don't know if this is going to always work, but somehow Eval() takes the string from the Dt (), and Query Builder accepts it.


I'm using Mike's code for Dt() here



I've been switching between USA and Latin regions for testing, so the dates may appear incongruent.

I don't know how Mike's function served him for 10 years for Nulls. It won't work with Eval(), and I doubt it will work in a string build for VBA to pass to SQL.
I'll do more testing.

After note: I had to go back and reread the blog by Mike, he does mention using the null for UPDATE and INSERT queries, and that it won't work in WHERE.
Quoth thy SQL? Evermore! (nolongerset.com)

[twgonder]

with regards attachments this is what I see


perhaps you didn't click the upload file

I have no idea, I didn't paste it and it shows in my uploads.
I may have switched to advanced mode while writing the post, and maybe that messed things up?
In any case, the links still work fine for me. Strange.