78. How do I convert a KFI Date field to a DateTime field

Setup a KFI Field (e.g. called Date_Created) and set its format tab options to a Date requiring DD/MM/YYYY format.

On the output tab, use the 'Add suffix to output value' option to add the (Time Processed) to the field. This will add the <<(Time Processed)>> string to the field.

Insert a space before this <<(Time Processed)>> string.

Modify the string to change the time default format from HHMMSS to HH:MM:SS

• <<(Time Processed)(hh:mm:ss)>> (note: there is a space at the start of this line!!!!!!

When the KFI field runs, EzeScan will take the date entered by the user in DD/MM/YYYY format and append to it the time in HH:MM:SS format. (E.g date value of 28/03/2007 and processed time of 17:10:05 would become 28/03/2008 17:10:05)

This value can then be passed into an upload DateTime field