With DocHub, you can quickly take out age in OSHEET from any place. Enjoy features like drag and drop fields, editable text, images, and comments. You can collect eSignatures safely, include an additional layer of protection with an Encrypted Folder, and collaborate with teammates in real-time through your DocHub account. Make adjustments to your OSHEET files online without downloading, scanning, printing or sending anything.
You can find your edited record in the Documents tab of your account. Prepare, email, print, or convert your file into a reusable template. With so many advanced features, it’s simple to enjoy effortless document editing and managing with DocHub.
to calculate the age in years calculate the difference between todayamp;#39;s date and date of birth on the create tab in the queries group click on query design add the employees table add employee id first name last name and date of birth in the query design grid in the field row right click an empty column and then click on zoom in the shortcut menu to calculate the difference between todayamp;#39;s date and date of birth use this expression click on ok run the query the query returns the number of days between the two dates and not the number of years switch back to design view and divide by 365 365.5 use parentheses to avoid errors due to order of operator precedence click on ok run the query now the query returns number of years decimal values are returned use the int function to remove the fractional portion run the query the int function doesnamp;#39;t round the ear up or down it merely removes the decimal part you can use the round function to round the number of years now
