By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,461 Members | 2,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,461 IT Pros & Developers. It's quick & easy.

EndDate and Date Now

P: 59
I have two bound combo boxes QuarterDate where a specific time period is selected and Dates with a set of four dates to choose from. What I would like to do in the Dates combo box is add a validation rule to say if the wrong date has been picked which should be after that day's date. I thought I could do this with a "Date() now" however it does not work.
Mar 3 '17 #1
Share this Question
Share on Google+
3 Replies

P: 4
I might not understand your question. Here are the properties for a combo box where the date selected has to be greater than the current date. If this is what you mean, then some refinements might have to be made because Now() has hours, minutes, and seconds; an entered date does not.
Control Source:
Row Source: "1/1/2017";"2/1/2017";"3/1/2017";"4/1/2017"
Row Source Type: Value List
Bound Column: 1

Validation Rule: >Now()
Validation Text: Oops, too early

The rest of the settings for the combo box use the default settings.
Mar 6 '17 #2

P: 59
Sorry if I'm not being clear or confusing the issue. The row source in each combo box is from the corresponding table as there are lots of different dates and quarters. There is another field in the form called End Date. This contains the date of when that specific payment period ends. Say the date in the End Date is 3/1/17 and the user has the option to choose from Dates 1/1/2017, 1/2/2017, 1/3/2017, 1/4/2017. I don't want them to pick a date prior to the End Date of 3/1/17.
Mar 7 '17 #3

Expert 100+
P: 1,107
You might be better off to limit your ComboBoxes to only Valid Dates. Then you won't need to use any validation.
Mar 8 '17 #4

Post your reply

Sign in to post your reply or Sign up for a free account.