I am trying to do a simple query. I need to find the users added to the table in the past 30 days.
I've tried these:
Between Date(now)-30 And Date(now)
Result: I get "function not available"
Between Month(now)-1 And Month(now)
Result: I get no records
>=Month(now)-1 And Month(now)
Result: I get no records
>=Month(now)-1
Result: I get all the records
>=Date()-30
Result: I get "function not available"
Can someone help me?
I've tried these:
Between Date(now)-30 And Date(now)
Result: I get "function not available"
Between Month(now)-1 And Month(now)
Result: I get no records
>=Month(now)-1 And Month(now)
Result: I get no records
>=Month(now)-1
Result: I get all the records
>=Date()-30
Result: I get "function not available"
Can someone help me?