How to filter for previous month data only?

[AccountingJ]

Hi everyone

I have

Please Login or Register  to view this content.

in date criteria that seems to return only last months data. I found this through Google, so can someone verify that's all it does?

Also, I'm somewhat familiar with functions in MAccess but never really spent time in learning the month/year functions. Can anyone explain to me how to write them or maybe give me a good link that shows me how to?

[JLGWhiz]

Here is the spec sheet on DateSerial.
https://docs.microsoft.com/en-us/off...erial-function

You can also search for Year, Month and Date vba functions on the web to get their spec sheets.

The snippet in the OP simply returns values between last month and this month. Code can be written to set criteria based on number of days, > or < a specific date, etc. Depends on what the user needs.

[AccountingJ]

what if I only wanted values for last month? and thanks for the link.

[JLGWhiz]

what if I only wanted values for last month? and thanks for the link.

I think The line of code in the OP pretty much does that. If you are not getting the right resullt, try changing the zero in the second DateSerial function to a 1 and see if that improves the results. It does not hurt to try the codes you find. In most cases the worst that can happen is that it will throw an error or shut down, but you should be using a mock file or copy to do your testing, not your original file. Only apply code you get from the internet to your original after testing it on another file that will not matter if it crashes.

[AccountingJ]

Thank you, when I read that you said it pulls last month and this month I thought I would get data for November as well when I didn't want that to be returned.

[JLGWhiz]

Thank you, when I read that you said it pulls last month and this month I thought I would get data for November as well when I didn't want that to be returned.

You're welcome,
regards, JLG