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

Limit

Limit the result at both the low end and also the high end, to no less than the limiting value in the At least field and also to no more than the limiting value in the At most field.  Save the Value field into the result,  unless that is below the At least field, in which case the At least field value is saved into the result, or unless that exceeds the At most field, in which case the At most field value is saved into the result.  Another way of looking at this is to take the Value field if it falls between the At least and At most fields, inclusive.   Yet another way is to consider simultaneously the At least field as the floor and the At most field the ceiling for what is taken from the Value field.

 

A literal datetime value can be specified in any parameter box by choosing Expression and then entering a datetime SQL style, bracketed by # # characters.

il_trans_limit_datetime_dlg.png

Preview: Put in Temp_datetime the Limit of Calendar as the Value, and the date of #12/15/2016 12:00:00# specified as the At least value, and the date of #12/18/2016 12:00:00# specified as the At most value.

il_trans_limit_datetime.png

In records where the Calendar date is between the specified At least and At most dates, the Calendar date is used.  Otherwise, the limiting low date specified in the At least box is used for dates that sort before the Calendar date and the limiting high date specified in the At most box is used for dates that sort after the Calendar date.

Limit High

Limit the result at the high end, to no more than the limiting value in the At most field.  Save the Value field into the result, unless that exceeds the At most field, in which case the At most field value is saved into the result.  Another way of looking at this is to take the minimum of the Value field or the At most field.  Yet another way is to consider the At most field the ceiling for what is taken from the Value field.

 

A literal datetime value can be specified in either parameter box by choosing Expression and then entering a datetime SQL style, bracketed by # # characters.

il_trans_limit_high_datetime_dlg.png

Preview: Put in Temp_datetime the Limit High of Calendar as the Value and the date of #12/15/2016 12:00:00# specified as the At most value.

il_trans_limit_high_datetime.png

In records where the Calendar date is before the high limit, that is, below the ceiling, specified in the At most box, the Calendar date is used.  Otherwise, the limiting high date specified in the At most box is used.

Limit Low

Limit the result at the low end, to no less than the limiting value in the At least field.  Save the Value field into the result, unless that is below the At least field, in which case the At least field value is saved into the result.  Another way of looking at this is to take the maximum of the Value field or the At least field.  Yet another way is to consider the At lease field the floor for what is taken from the Value field.

 

A literal datetime value can be specified in either parameter box by choosing Expression and then entering a datetime SQL style, bracketed by # # characters.

il_trans_limit_low_datetime_dlg.png

Preview: Put in Temp_datetime the Limit Low of Calendar as the Value and the date of #12/15/2016 12:00:00# specified as the At least value.

il_trans_limit_low_datetime.png

In records where the Calendar date is after the low limit, that is, above the floor, specified in the At least box, the Calendar date is used.  Otherwise, the limiting low date specified in the At least box is used.

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