Takes six parameters, FieldBase, Destination, Function, Source, Value, IfLenFld

Usage:

FieldBase, Destination, Function, Source, Value, IfLenFld
[WorkWith], Destination, Function, Source, Value, IfLenFld
[WorkWith], Destination, Function, Source, Value, [""]
[WorkWith], Destination, Function, Source, [""], [""]
FieldBase, Destination, Function, Source, Value, [WorkIf]
[WorkWith], Destination, Function, Source, Value, [WorkIf]
[WorkWith], Destination, Function, Source, [""], [WorkIf]

Description:

An optimized way to perform time manipulation of DateTime data in bulk on multiple records simultaneously.

Evaluates the Function and places the requested value into the Destination Field.

List of Functions:

• Add source, val
• Sub source, val
• Dif source, val
• Zone source, val

Note: The Time command is focused on working with [DateTime] data. The Text and Num commands have many other date and time related functions that deal with dates or time separately.

Example:

LoadTable   "Finance.Product"
WorkWith    "Finance.Product"
    NewFields    "Age"
    Time         "Age", "Dif", "Created", ($Now)
End WorkWith