How to avoid Data type mismatch in this query

[Middlemarch]

I'm getting Data type mismatch in criteria expression.


SELECT tblMain.LastBatch


FROM tblMain
WHERE (((tblMain.LastBatch)>CLng("getStoreddate")));


getStoreddate is a UDF that returns a date. But Access puts quotes around it, and I think that's the problem.
LastBatch is a Long number field.
How might I get this to work? Thanks.

[CJ_London]

if it is a function, you need to include brackets

CLng(getStoreddate())

[Middlemarch]

Thank you. Forgot.

[June7]

Nitpicking here: those are parentheses. These are brackets: [ ]. These are braces { }.

[Minty]

Nope these are braces:

[CJ_London]

according to ascii

DEC	OCT	HEX	BIN	Symbol	HTML Number	HTML Name	Description
40	050	28	00101000	(	(	&lparen;	Open parenthesis (or open bracket)
41	051	29	00101001	)	)	&rparen;	Close parenthesis (or close bracket)
91	133	5B	01011011	[	[	[	Opening bracket
93	135	5D	01011101	]	]	]	Closing bracket
123	173	7B	01111011	{	{	{	Opening brace
125	175	7D	01111101	}	}	}	Closing brace

[June7]

No, those are suspenders