PDA

View Full Version : Solved: month and year



ProteanBeing
12-28-2007, 11:13 AM
I would like to prompt the user to enter in the month and the year and filter a list to show all rows within the month. I can't think of how to do it. Any ideas/suggestions?

Bob Phillips
12-28-2007, 11:20 AM
Why not just add a column to extract the month and year and add a filter to that column, then the user can filter at will.

ProteanBeing
12-28-2007, 11:36 AM
Thanks for your idea. However I figured out what I needed to know. I used DateSerial function

LastDay = DateSerial(UserYear, UserMonth + 1, 1 - 1)

Bob Phillips
12-28-2007, 02:57 PM
Just FYI, there is absolutely nothing in your original post that would have led us to that. You mention Filter, where is the filter in that? You mention a promt, there is no prompt there. Where did UserYear come from? And UserMonth? And how does it show anything? Just thoughts for the next time.