StepType_FormattedDateTimeString

FormattedDateTimeString

Returns a string containing a date information into the parameter "cFormattedDateTimeString" based on the given format and time ofset

How each column is used:

Column Name	Value
iID	The ID used to uniquely identify the current Step Sequence
iSeq	Optional/Purely cosmetic, only used to help you structure you step sequences
cStepType	FormattedDateTimeString
cField	Formatting String
cValue	An offset in days (can be negative and decimal e.g -0.5 would give 12 hours ago)
cTiming	Not Used
cExpect	Not Used
cOnError	Not Used

Formatting options:

String	Result Returned
yyyy	A 4 digit representation of the year e.g. 2014
yy	A 2 digit representation of the year e.g. 14
m or mm	A 2 digit representation of the month e.g. 02, 12
d or dd	A 2 digit representation of the day e.g. 03, 28
H or HH	A 2 digit representation of the hour in 24 hour time e.g. 00, 23
h or hh	A 1 to 2 digit representation of the hour in 12 hour time e.g. 01, 12
M or MM	A 2 digit representation of the minute e.g. 01, 58
S or SS	A 2 digit representation of the seconds e.g. 00, 59
s or ss	A 2 digit representation of the seconds e.g. 00, 59
t or tt	AM or PM

Example usage:

iID	iSeq	cStepType	cField	cValue	cTiming	cExpect	cOnError
Seq001	1	FormattedDateTimeString	yyy-mm-dd HH:MM:SS	0