Currant Month code not working

[lsearcey]

I put the following info in the criteria section on a query for a table and it says that "the expression you entered has a fuction containing the wrong number of arguments"

=format(Month(Now(),mmm)&format(Year(Now(),yy)

I'm try to find a way to get it to filter out just the currant month from the Enroll Month field. The table field the query is looking at has the date listed in 01/01/2005 format.

Thank You

 

[nbrcrunch]

edited:

excuse the post. I didn't notice this was for MS_Access.

 

[Andrew Fergus]

Hi
You are missing some closing brackets and some quotes. Try this instead:
Format(Month(Now()),"mmm") & Format(Year(Now()),"yy")
HTH, Andrew

 

[Andrew Fergus]

On reflection I don't think this will give you what you want given the format of the enrol date field is different to what you were trying to do in your criteria. If you are trying to filter a date field in a query just to include the records from the current month, then use this criteria under your enrol date field :

>DateAdd("d",-Day(Date()),Date()) And <DateSerial(Year(DateAdd("m", 1 ,Date())), Month(DateAdd("m", 1, Date())), 1)

This picks up all records after the last day of the previous month and before the first day of the next month.

BTW a format of 01/01/2005 could be either 1 Jan 2005 or Jan 1 2005 depending on where you are from and what sort of date convention you use.

HTH, Andrew