Simple Date Question 
Author Message
 Simple Date Question
Please forgive me, I'll bet this is the easiest question here BUT....
I'm trying to create a simple calculation that will give me a date
one-year from a previous date (date of hire). The 'Date of Hire' field
is a date field formatted as MM/DD/YY. What is the calculation so that I
can have a new field one-year, two-years, etc. from that date with that
format?
Anyone?




Tue, 30 Apr 2002 03:00:00 GMT
 Simple Date Question

Use the Date Function in a calculation:
Date(Month(MM/DD/YY),Day(MM/DD/YY), Year(MM/DD/YY) + 1)  for one
additional year.

Quote:

> Please forgive me, I'll bet this is the easiest question here BUT....
> I'm trying to create a simple calculation that will give me a date
> one-year from a previous date (date of hire). The 'Date of Hire' field
> is a date field formatted as MM/DD/YY. What is the calculation so that I
> can have a new field one-year, two-years, etc. from that date with that
> format?
> Anyone?



--
Mike Ross
Digital Designs
(360) 943-8408 / Fax:  (630) 839-3774

www.rossdigital.com


Wed, 01 May 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Simple date question!!

2. Simple date question

3. simple date question

4. Simple Date Question

5. Probably Simple - Date question

6. simple date question

7. simple date question

8. Simple Date Question that I can't find the answer to.

9. SQL7, SIMPLE SIMPLE SIMPLE question

10. Simple Date Comparison Question

11. Simple Date Format Question


 
Powered by phpBB® Forum Software