473,756 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help - Close Date and Effective Date

Hi

I built a database application and I have a field which is for the Close
Date. But I need to create an effective date that it will come out
automatically. The Effective Date should be 6 months after the Close Date.
How can I do this?

Any help I would really appreciate it.

Thanks,
Ely

Jul 17 '05 #1
2 2286
Ely,

Look at the DateAdd function in the Help file.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"Evelyn Pabón" <ep****@coqui.n et> wrote in message
news:FP******** *********@fe39. usenetserver.co m...
Hi

I built a database application and I have a field which is for the Close
Date. But I need to create an effective date that it will come out
automatically. The Effective Date should be 6 months after the Close Date.
How can I do this?

Any help I would really appreciate it.

Thanks,
Ely

Jul 17 '05 #2
First some assumptions...
1. The field that you are storing it in is of type "Date" rather than
type "Text".
2. You want the same day number of the month. jan 1 to june 1... not 180
days.
DateAdd(m, 6, [Open Date])

[Open Date] is the field that has the start date.. You may need to fully
qualify the field. If you use build and select the field it will do the
work for you.

Chris

Evelyn Pabón wrote:
Hi

I built a database application and I have a field which is for the Close
Date. But I need to create an effective date that it will come out
automatically. The Effective Date should be 6 months after the Close Date.
How can I do this?

Any help I would really appreciate it.

Thanks,
Ely

Jul 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
3473
by: abcd | last post by:
kutthaense Secretary Djetvedehald H. Rumsfeld legai predicted eventual vicmadhlary in Iraq mariyu Afghmadhlaistmadhla, kaani jetvedehly after "a ljetvedehg, hard slog," mariyu vede legai pressed Pentagjetvedeh karuvificials madhla reachathe strategy in karkun campaign deshatinst terrorism. "mudivae maretu winning or losing karkun global varti jetvedeh terror?" Mr. Rumsfeld adugued in a recent memormariyuum. vede velli jetvedeh madhla...
9
3137
by: netpurpose | last post by:
I need to extract data from this table to find the lowest prices of each product as of today. The product will be listed/grouped by the name only, discarding the product code - I use SUBSTRING(ProductName, 1, CHARINDEX('(', ProductName)-2). I can get this result, but I had to use several views (totally inefficient). I think this can be done in one efficient/fast query, but I can't think of one. In the case that one query is not...
3
15932
by: Josh | last post by:
I need a query that will select the closest date. I have to tables Pricing and InventoryItem. tblInventoryItem InventoryItemID <- Pk Description tblPricing
1
1311
by: Sarah Katon | last post by:
Hi all. I'm fairly new to VB.net, and I have very little experience with Javascript. I'm trying to get a Client Side Custom Validator to work for many interrelated controls. I'd like to check several fields and update the Error Message on the fly, and then have at least one error message shown in a message box. How do I write the Javascript? Should it be in the html code behind the form? Or do I use the append function? I've...
10
3483
by: Susan M. | last post by:
I'm trying to do a query that joins two tables. The trick is that I only want it to return rows based on a certain criteria. Table 1: Inventory Fields: Inventory #, Description Table 2: Prices Fields: Inventory #, Price, Effective Year, Effective Month, Effective Day
2
1303
by: Evelyn Pabón | last post by:
Hi I built a database application and I have a field which is for the Close Date. But I need to create an effective date that it will come out automatically. The Effective Date should be 6 months after the Close Date. How can I do this? Any help I would really appreciate it. Thanks,
1
280
by: kufre | last post by:
Problem 1 - I have a query setup to run a report. How could I filter out some record from a field called Status Effective Date from my report only if it is 30 days prior to when the report is printed. Problem 2 - I'm trying to make a field a required field only if a condition in another field is met. Example: I want to make Target Follow-up date a required field only if submission date is entered. Thanks in advance, any help will be...
2
1304
by: CK | last post by:
Good Morning, I have a view that contains rate information, contractIDs, and effective dates. I need to select the rate info based on contractID and date. I can provide a date and contractID, and I need to select the rate info for that contract where the effective date is <= dateprovided. I need the 1 record that is closest to that date. I am thinking something with max() perhaps. Any ideas? The <= effective
9
3020
by: jbaranski | last post by:
Access 2003 on XP pro machine... i'm running a crosstab query and an export to a 3rd party company showing different benefit plans for employees; specifically dental, vision and medical pulling the effective dates (date which the plan when into effect). generally the plans all have the same effective date. however in the case they don't 2 lines are returned for the same employee; the first containing, for example, their medical and vision...
0
9455
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9869
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9838
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9708
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8709
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7242
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5140
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5302
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3354
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.