This Month Date Range Button (1 Viewer)

[mugen_rsx]

Is it possible that I create a button and after I click it, it will show only "This Month" or "Last Month" Database? If today is Dec 14th, I click on "this month" button and it will show Dec 1-14th data.

Is it better to work this on Query? Sorry I am a newbie, still couldn't know when to use Query!

I have read some posts and they only talk about typing 2 specific dates! Please help!!

 

[bradcccs]

You will find some great date examples here:

http://www.access-programmers.co.uk/forums/showthread.php?t=62570

I realise you said you are a newbie, but you should find a solution in Pat's example that you may be able to adapt.

Cheers

 

[MStef]

Hello bradcccs!
Look at "DemoThisMonthA97.mdb"
(MStef alias Štef)

 

[MStef]

My mistake again it's for mugen-rsx.

 

[Christopherusly]

Runtime error "13" - Type mis match when running your sample database

Function FirstOfNextMonth(datAny)
' Returns the first day of the month following the specified month.
FirstOfNextMonth = DateSerial(Year(datAny), Month(datAny) + 1, 1)
End Function

Sadly i do not know why, any suggestions ?

 

[MStef]

Hello Christopherusly!
I suppose you call function with empti field "datAny".
You have to fill it with date before.