Difference between revisions of "TIME - Format a time (Reports & Settings Report Generator function)"

From Catalyst
Jump to: navigation, search
(Updated from revision control)
(Updated from revision control)
 
Line 43: Line 43:
 
:Seconds.
 
:Seconds.
  
 +
{{KB_Tags|time, hours, minutes, seconds}}
 
[[Category:Reports & Settings Report Generator functions]]
 
[[Category:Reports & Settings Report Generator functions]]

Latest revision as of 06:43, 15 February 2018

Syntax

$TIME{time, unit}

Description

Format a full time string.

Use the $SUBSTR function to extract time elements.
$SUBSTR{$TIME{},4,8}
will give you hh:mm:ss.
$SUBSTR{$TIME{},4,5}
will give you hh:mm.


Parameters

time
A numeric parameter that can be omitted.
The time in numeric format. If omitted, the current machine time is used.
unit
A text parameter that can be omitted (it defaults to "S").
Is the given time in Minutes or Seconds?
M
Minutes
S
Seconds

Returns

A text value. The formatted time text in the following format: dd:hh:mm:ss, where:

dd
Days.
hh
Hours.
mm
Minutes.
ss
Seconds.


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
time, hours, minutes, seconds