Date problem
in [General]
|
Prev: Do Long Names Corrupt?
Next: RR
From: Charlie O'Neill on 22 Apr 2010 13:11 I thank all of you for some great suggestions. It seems simple when you know what you are doing. "John W. Vinson" wrote: > On Wed, 21 Apr 2010 21:07:01 -0700, Charlie O'Neill > <CharlieONeill(a)discussions.microsoft.com> wrote: > > >I have customer accounts that expire on various dates. Once a month a > >mailing list must be printed. On a form I am using a control which is > >formatted as a date picker. When a clerk enters a date in the control any > >accounts => than the date will print. The problem is if the clerk enters a > >date of 5/12/2010 any account dated between 5/1 and 5/11 does not print. > > > >I want to change the control to a drop down showing Jan, Feb, Mar etc. When > >the clerk picks May I want a hidden control 'Mail' to show 5/1/2010 and use > >this control for my query. > > Consider having a combo box cboMonth with twelve rows and two fields: > MonthName and monthNo (January = 1, February = 2 and so on). Display the month > name but use the monthno as the bound column. > > You could use a criterion > > >=DateSerial(Year(Date()), Forms!YourForm!cboMonth, 1) AND < DateSerial(Year(Date()), Forms!YourForm!cboMonth + 1, 1) > > to get all dates in the selected month during the current year. > > If you're worried that they'll pick February and expect it to pull February > 2011, you can use somewhat more complex expressions to get the right year. > -- > > John W. Vinson [MVP] > . > |