Transform Templates - Datetime

This topic discusses application of the Transform panel with Tables on a datetime field in a table.   See the Transform panel and Transform Templates topics for use and for links to lists of templates for other data types for tables and use of the Transform panel with other components, such as Drawings and Images.

Tables, Datetime Type

Copy

Copy the source field into the target field.  A literal datetime value can be specified by choosing Expression and then entering a datetime SQL style, bracketed by # # characters.

 

il_trans_copy_datetime_dlg.png

Preview: Copy Calendar into Temp_datetime.

il_trans_copy_datetime.png

Maximum Value

Take the maximum, that is the greater value, of either the source field or the comparison field and save into the target field.  A literal datetime value can be specified as the Compare to value by choosing Expression and then entering a datetime SQL style, bracketed by # # characters.

il_trans_max_value_datetime_dlg.png

Preview: Put in Temp_datetime the Maximum Value of Calendar or #12/15/2016 12:00:00#.

il_trans_max_value_datetime.png

Minimum Value

Take the minimum, that is the lesser value, of either the source field or the comparison field and save into the target field. A literal datetime value can be specified as the Compare to value by choosing Expression and then entering a datetime SQL style, bracketed by # # characters.

 

il_trans_min_value_datetime_dlg.png

Preview: Put in Temp_datetime the Minimum Value of Calendar or #12/15/2016 12:00:00#.

il_trans_min_value_datetime.png

Parse Base64 String

Extracts a datetime value encoded into a base64-encoded string and places it in the target datetime field.

 

Parse Hex String

Extracts a datetime value encoded into a hex-encoded string and places it in the target datetime field.

 

See Also

Contents Pane

 

Transform

 

Contents - Transform

 

Transform Options

 

Transform Templates

 

Transform Templates - Drawings

 

Transform Templates - Images

 

Transform Templates - Binary

 

Transform Templates - Boolean

 

Transform Templates - Geom

 

Transform Templates - Numeric

 

Transform Templates - Text

 

Transform Templates - Tile

 

Transform: Center and Centroids

 

Transform: Escape Templates