filter per date

[rjmdc]

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

 

[Cubist]

how do I change to be the first of the month of the date I am exporting?

DateStart = Application.WorksheetFunction.EoMonth(Date, -1) + 1

how do i change to be end of the month of the date i am exporting?

DateEnd = Application.WorksheetFunction.EoMonth(Date, 0)

how do i change to be the month and year of the date i am exporting?
Which day?

 

[Fuji]

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

    [a1].AutoFilter 1, , 7, Array(1, Date)

Range.AutoFilter method (Excel)

Office VBA reference topic

learn.microsoft.com