Create appointment types with corresponding e-mails

You can save time by designing various Appointment types. When you do, each time you choose an appointment type for a booking, the info or links you’ve structured (e.g. parking instructions, appointment prep details) will be e-mailed to attendees without any further action. Select More options  > Settings. Pick Appointment types >   Add appointment type. Please bear in mind that whatever youContinue reading “Create appointment types with corresponding e-mails”

Export time reporting in Shifts

Applies to: Office for business, Microsoft Teams. Is exporting your team’s time tracking for documentation or reporting purposes a top priority? You can export Shifts time clock reports to an Excel worksheet with only a few steps. Note: Employees can edit their time sheets on mobile for up to one month or until confirmed. All original andContinue reading “Export time reporting in Shifts”

Set up the time clock for Shifts

Applies to: Office for business, Microsoft Teams. Employees can deploy the time clock to clock in and out with their mobile devices. Managers can format optional location detection, which identifies where employees are once they clock in and out. These settings are modifiable or removable at any time.  Set up the time clock In Shifts, choose Settings in theContinue reading “Set up the time clock for Shifts”

Manage settings in Shifts

Applies to: Office for business, Microsoft Teams. In this article Set the time zone Set the start of the week Add or edit time off request types Turn on Open shifts Set the time zone Click Settings in the top left corner of the app. Choose the specific team’s time zone under Team time zone, and then pickContinue reading “Manage settings in Shifts”

Turn off adding apps to Teams

Applies to: Microsoft Teams. If you’re a team owner, you can determine if team members have the autonomy to append apps. Navigate to the team name and select More options  > Manage team > Settings > Member permissions. Then, check or uncheck the box called Allow members to add or remove apps.

Weekday Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Integer) containing a whole number representing the day of the week. Syntax Weekday( date [, firstdayofweek ] ) The Weekday function syntax has these arguments: Argument Description date Required. Variant, numeric expression, string expression, or any combination of these that can represent a date. If date contains Null, Null is returned. firstdayofweek Optional. AContinue reading “Weekday Function”

DatePart Function

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Integer) containing the specified part of a given date. Warning   – There is an issue with the use of this function. The last Monday in some calendar years can be returned as week 53 when it should be week 1. For more information and a workaround,Continue reading “DatePart Function”

DateDiff Function

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Long) specifying the number of time intervals between two specified dates. Syntax DateDiff ( interval, date1, date2 [, firstdayofweek] [, firstweekofyear] ) The DateDiff function syntax has these arguments: Tip: In Access 2010, the Expression Builder has IntelliSense, so you can see what arguments your expression requires.  Argument Description interval Required. String expression thatContinue reading “DateDiff Function”