A date and time function string defines the date time value resulting from a formatting operation and defines the date time value required to convert one date and time string to the required date and time string format.
There are two computed column types for date time values:
-
DateTimeColumn - This column is for the date and time for a specific time zone. The parameters are column, format of the input value, and time zone, for example, func.DateTimeColumn([InputColumn], "Input value format", "TimeZone"). Using this format the input value is converted to SPFDateTime format, yyyy/MM/dd-HH:mm:ss:fff.
For example, the input value is 12/06/2015-09:00:00 and the input value format is "dd/MM/yyyy-HH:mm:ss", time zone is "Central Standard Time". Therefore, the input value is converted to SPFDateTime format, 2015/06/12-14:00:00:000,GMT.
-
YMDColumn - This column is for the YMD format. The parameters are the column name and the format of the input value, for example func.YMD([InputColumn], "Input value format"). Using this format, the input value is converted to the SPFDate format, yyyy/MM/dd.
For example, the input value is dd/MM/yyyy format (12/06/2015), which is converted to SPFDate format that is yyyy/MM/dd (2015/06/12).
-
The DateTime rule should only be configured on YMD or DateTime computed columns.
-
The time zones mentioned in the computed columns must match with the Microsoft Time Zone Index Values available in your system.