Calculating age based on dates 1

[shiela]

I'm trying management tenure by month based on hire date or promotion date.

 

[RickSpr]

Subtracting an earlier date from a later date will give you the number of days between them. If you want more specific advice, we'll need a more specific question. Rick Sprague

 

[shiela]

Thanks. Basically I have an employee, their orginal hire date, and their effective date to a position (manager level). I also have a fiscal calendar with the month ending date. I need to get a beginning and end of fiscal month tenure. So should I hire and effective date from the end of month dates to get a monthly tenure? I tried to subtract them and I got an error.

 

[RickSpr]

You may have gotten the error because the values weren't Date types. You can't do arithmetic on strings that contain date values. What kind of error did you get, and what data types were you using? Rick Sprague

 

[shiela]

Thanks. I found the datediff function and you're right my dates were not formatted right.