filter per date

rjmdc

Well-known Member
Joined
Apr 29, 2020
Messages
743
Office Version
  1. 365
Platform
  1. Windows
hi
my present code is set for the end of the month
i need to update to filter and export on demand
current : DateStart = Application.WorksheetFunction.EoMonth(NextPromptDate, -2) + 1 how do I change to be the first of the month of the date I am exporting?
current: DateEnd = Application.WorksheetFunction.EoMonth(NextPromptDate, -1) how do i chnage to be end of the month of the date i am exporting?
current: ReportMonth = Application.WorksheetFunction.EoMonth(NextPromptDate, -2) + 1 how do i change to be the month and year of the date i am exporting?

once i can update my parameters then my filters will work
thanks
 
how do I change to be the first of the month of the date I am exporting?
VBA Code:
DateStart = Application.WorksheetFunction.EoMonth(Date, -1) + 1

how do i change to be end of the month of the date i am exporting?
VBA Code:
DateEnd = Application.WorksheetFunction.EoMonth(Date, 0)

how do i change to be the month and year of the date i am exporting?
Which day?
 
Upvote 0
my present code is set for the end of the month
i need to update to filter and export on demand
If it is done by AutoFilter and you want to filter only current month then no need to find those days.
e.g
Code:
    [a1].AutoFilter 1, , 7, Array(1, Date)

 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,918
Members
453,766
Latest member
Gskier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top