User guide

Creating a Data Extract Export Job (Export Extracted Data/Data Extract Export Job)
www.iprotech.com Ipro eCapture User Guide 7-169
877-324-4776 Q1 2014
Date Field Formatting: If you want to change the date field to a different
format, select from the following formats:
• YYYYMMDD
• YYYY/MM/DD
• MMDDYYYY
• MM/DD/YYYY
• DD/MM/YYYY
Otherwise, select the option, Do Not Convert Date Fields.
Time Format: Select from:
• 12-hour [displays time in 12 hour format e.g. 1:04]
• 24-hour [displays time in 24 hour format, e.g. 13:04]
• Regional [formats the time according to the “default” Regional Settings
of the Worker the document is being exported on. Note: Changing the
format strings using the “Customize” button of Regional Settings will
have no effect; the actual region needs to be changed to see any effect.
Resolve Times to Second Precision: Select this option if you want to add
seconds to all metadata date fields that have time. This does not apply to the
images.
Invalid date options
Treat date values outside of specified range as invalid dates - Select a
start date and end date range. Any dates outside of the selected range will be
considered as invalid dates. The start date default is set to SQL minimum date.
The end date default is set to SQL maximum date.
Select one of the following options:
• Invalid date field output value - enter text to display in the event an
invalid date is encountered. This field may be left blank.
• Invalid date field output do not convert - invalid dates will be output
as a text field.