getdate() in ms access

[Ashley]

IF I have


sum(IIF (datediff('d', getdate(), #22/11/2003#) between 0 and 30 , 1 ,
0))

it says getdate() not a recognisex function where getdate() is todays
date

what is the way of doing this in access

 

[RoyVidar]

IF I have


sum(IIF (datediff('d', getdate(), #22/11/2003#) between 0 and 30 , 1
, 0))

it says getdate() not a recognisex function where getdate() is todays
date

what is the way of doing this in access

GetDate is a SQL server function, I think. Use the Date() function in
Access to return todays date.

 

[Guest]

Use Date() for the current date.

Use Now() for the present date with time.

 

[Guest]

It is not getdate() it is just Date()