TIMETOUSERTZ(date_num, time_num)

 

Time Function Returns a Numeric Value
Returns the time value in the user’s timezone of a Coordinated Universal Time (UTC) date and time. The TIMETOUSERTZ( ) and DATETOUSERTZ( ) functions are used together to convert a time from UTC to the user’s local time zone. The time zone is retrieved from the Calendar Properties program in the PracticeMaster software, or from the Windows clock setting.

• The first parameter (date_num) is the numeric date value in UTC time.
• The second parameter (time_num) is the numeric time value in UTC time.
  
  

Note: Most dates and times in Tabs3 Software are not stored in Coordinated Universal Time (UTC). Only the PracticeMaster Calendar file stores date and time values in UTC.

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)

 

See also:

DATETOUSERTZ( )