K
Kay
I HAVE A BENEFITS DATABASE THAT INCLUDES A FIELD [BENEFITS ELIGIBILTY]. i
WANT TO SET THE DEFAULT VALUE. THE ELIGIBILTY DATE SHOULD BE 7 MONTHS
FOLLOWING THE [START DATE]
FOR EXAMPLE.
[FIRST NAME],[LAST NAME],[START DATE],[BENEFITS ELIGIBILTY]
JOHN DOE 07/02/2008 01/2008
I CANT EVEN GET PAST THE FIRST PART, MONTH([STARTDATE])+7 BECAUSE IF THE
MONTH IS 12, IT RETURNS WITH 19????
I ALSO NEED IT IN MM/YYYY FORMAT SO THAT I CAN QUERY IT LATER WITH DATE
EXPRESSIONS AND CRITERIA.
WANT TO SET THE DEFAULT VALUE. THE ELIGIBILTY DATE SHOULD BE 7 MONTHS
FOLLOWING THE [START DATE]
FOR EXAMPLE.
[FIRST NAME],[LAST NAME],[START DATE],[BENEFITS ELIGIBILTY]
JOHN DOE 07/02/2008 01/2008
I CANT EVEN GET PAST THE FIRST PART, MONTH([STARTDATE])+7 BECAUSE IF THE
MONTH IS 12, IT RETURNS WITH 19????
I ALSO NEED IT IN MM/YYYY FORMAT SO THAT I CAN QUERY IT LATER WITH DATE
EXPRESSIONS AND CRITERIA.