Home
CreateTextColumnFromDateColumn
Create a text column made of date/time elements from a date column.

Syntax:

CreateTextColumnFromDateColumn, dateColumnName, newTextColumnName, tildeDelimitedElements 

Parameters:

dateColumnName - the name of the date column to use

newTextColumnName - the name for the new text column that is to be created

tildeDelimitedElements - tilde-delimited list of date-time elements { year, month, day, hour, minute

Examples:

CreateTextColumnFromDateColumn,Date,Period,year~month~day~~

From the values in the date column labelled "Date", create a new text column labelled "Period" that contains the year, month and day elements (e.g. 2005/04/17).

Author Mode menu:

Data -> Create new Text Column from Date

 

 

 

 

 

 
< Prev   Next >

Reference