ms access - <= todays date in the same month i -


hi im trying return values date/time field in same month <= todays date

i've tried

month(<=now())    month(<=date()) 

into expression field within query builder

which looks month([followupdate])

can point me in right direction?

thanks

you can use criteria followupdate:

between dateserial(year(date()), month(date()), 1) , date() 

indeed if have index on followupdate.


Comments