473,396 Members | 2,099 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

EndDate and Date Now

62 32bit
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
3 855
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
glat
62 32bit
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
jforbes
1,107 Expert 1GB
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

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

Similar topics

6
by: Stuart Palmer | last post by:
I am trying to compare the current date() with the date in an access db to pull out only records where the date is later than the todays date (so records where the date hasn't passed) Then I do...
4
by: Peter Bailey | last post by:
I have a vba string taht dynamically creates the query which has two dates in it that it grabs off an open form as a string from the textbox. What I generate in vba is: SELECT DOSMBK.Date,...
3
by: manning_news | last post by:
Using A2K. I've been asked to modify a report currently requiring only one date parameter to now accept a date range. The main report has 2 subreports and is not bound to a table or query. The...
2
by: hyde | last post by:
How can I get the current date to appear in a form - but also be able to change that date permanantly example i have a start date and and end date for my clients these two date calculate in...
2
by: Cy | last post by:
I have a custom access 2000 database, that has contracts with starting and ending dates. What I'd like to be able to do, is key in a date, say today 9/2/05 and get a list of all "current"...
6
by: MarkAurit | last post by:
Im having difficulty coming up with a good algorithm to express the following comparison: "if <a given date> falls between the (current date - 5 days) and the (current date)" Obviously....
3
by: Shevek | last post by:
Hi All, Hope someone can help! I am building an Event Calendar app based around the Calendar WebControl which builds an SQL string based on the SelectedDates property which is passed to...
1
by: Lauren Quantrell | last post by:
I already figured out (the hard way) I need to convert all my date parameters into USA format before executing my stored procedures where dates are used as parameters. (Format(StartDate, "m/d/yyyy...
11
by: Lauren Quantrell | last post by:
I already figured out (the hard way) I need to convert all my date parameters into USA format before executing my stored procedures where dates are used as parameters. (Format(StartDate, "m/d/yyyy...
4
by: AXRabbit | last post by:
Hi, i am now doing a Car rental system web project. Well the interface is very similiar to http://www.avis.com.sg/, which i have extra modelname dropdownlist. Here is my code.Label 7 is just a...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.