The FIRST STEP is to check the 'Use Date' and/or 'Use Time' box

Click in the Image on "Next - Back" or "Save" or "Cancel" to Navigate

The SECOND STEP is to define the 'Use TODAY' and/or 'Use CLOCK' options OR

( this will use the current DATE or TIME as value for this column)

The SECOND is to select from the relevant drop down lists the source column to use

( this will perfom a proper reformating of the selected column's value)

NOTE 1 : when you are working on a STRING SOURCE Column containing a DATE or a TIME extra drop down boxes (on the right side of "Use Date" and "Use Time") will be used to let you define a deformating option to apply (choices from D1 to D018).

NOTE 2 : you can use a second extra drop down box to let you define a formating option to be aplied in Destination Table value (choices from D1 to D018).

example (STRING columns in source and destination) : source value is YYYY-MM-DD and destination is DD/MM/YYYY

1. use the TOP (deformat) dropdown and select D10- to get a LONG value of the source one
2. use the BOTTOM (format) dropdown and select D6 to format the LONG (generated from the DEFORMATING) into your final destination value

The LAST STEP is to click on the "Next - Back" button or on the "Save" one