ContributionsMost RecentMost LikesSolutionsRe: Calculate Years of Employee between a date/time field and todayIt worked! Thank you so very much! Happy New Year! ------------------------------ Laura Diak ------------------------------ Re: Calculate Years of Employee between a date/time field and todayThank you. ------------------------------ Laura Diak ------------------------------ Re: Calculate Years of Employee between a date/time field and todayThank you, Don. I was able to get the first part working. How would you suggest I set up the formula for the second part? ------------------------------ Laura Diak ------------------------------ Calculate Years of Employee between a date/time field and todayI am trying to develop a field that automatically calculates the years of employment (including months & days) using a date/time field (Date of Hire) and whatever day it is currently. Thank you in advance! ------------------------------ Laura Diak ------------------------------ How to see when a report was created & who created itI am trying to see if I can find out when a report was created, & what user created it. I know that information is found at the bottom of the page in the tables, but I can't figure it out for the reports. ------------------------------ Laura Diak ------------------------------ Re: Syntax Error The expression[Grease Location Opening Date]on the left hand side of the operator "+" is of typedatewhile the expression[FREQUENCY]on the right hand side is of typenumber. The operator "+" cannot be used with these types of expressions. ------------------------------ Laura Diak ------------------------------ Syntax ErrorFormula syntax error There must be a valid expression inside parentheses. AdjustMonth([Grease Location Opening Date],(ToNumber([FREQUENCY])/4),(Date d)Firstdayofweek)) The "Grease Location Opening Date" will be manually entered. I would like the "Week of First Collection" field to auto-populate by taking the opening date & adding the frequency (in weeks) to get to date of the first collection. Then I would like that field to show the date for the first day of the week. So, the "week of first collection" date will always be a Sunday. ------------------------------ Laura Diak ------------------------------