MS Query - DateSerial Anomaly

[SkipVought]

When I use

DateSerial(Year(Date()+90), Month(Date()+90)+1, 0)

in the Select Clause, it returns a valid end-of-month date.

in the Where Clause, I get an error
[tt]
Wrong number of arguments used with function in query expression
'(MOI.PCT<=DateSerial(Year(Date()+90),Month(Date()+90)+#1/1/2000 00:00:00#))'.
[/tt]
Any ideas?

Skip,

_[red][/red]

 

[PHV]

(MOI.PCT<=DateSerial(Year(Date()+90),Month(Date()+90)+[!]1,0[/!])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

PH,

The MS Query Editor is taking
[tt]
MOI.PCT<=DateSerial(Year(Date()+90), Month(Date()+90)+1, 0)
[/tt]
and interpreting it as
[tt]
(MOI.PCT<=DateSerial(Year(Date()+90),Month(Date()+90)+#1/1/2000 00:00:00#))
[/tt]

SELECT MOI.PART_ID, MOI.MFG_ORD, MOI.PROGRAM, MOI.RC, MOI.LPCT, MOI.CURRENT_OP

FROM  `\\dfwsrv222\public\HeldForMaterial\HFM`.FPRPTSAR_MFG_ORDER_INFO MOI

WHERE MOI.PCT <= DateSerial(Year(Date()+90), Month(Date()+90)+1, 0)

[tt]
[highlight blue][white] Microsoft Query [/white][/highlight][highlight white]
Wrong number of arguments used with function in query expression
'(MOI.PCT<=DateSerial(Year(Date()+90),Month(Date()+90)+#1/1/2000 00:00:00#))'.[/highlight]
[/tt]


Skip,

_[red][/red]

 

[SkipVought]

This seems to work...

WHERE MOI.PCT <= DateSerial(Year(Date()+90), Month(Date()+90)+Val(1), Val(0))

Skip,

_[red][/red]