During the data upload process the following date, timestamp and number formats are automatically parsed and passed to the database.
Automatically Supported Date Format Masks
'MM/DD/RRRR'
'DD/MM/RRRR'
'DD/MM/RR'
'fmMM/DD/RRRR'
'fmDD/fmMM/RRRR'
'RRRR.MM.DD.'
'DD-MM-RR'
'DD.MM.RRRR'
'DD/MON/RR'
'RRRR-MM-DD'
'DD-MM-RRRR'
'fmDD/MM/RRRR'
'RRRR/MM/DD'
'DD.MM.RR'
'fmRRRR/MM/DD'
'fmDD.MM.RRRR'
'MM/DD/RRRR'
'RRRR.MM.DD'
'fmDD-MM-RRRR'
'RRRR-MM-DD"T"hh24:mi:ss'
Automatically Supported Timestamp Format Masks
'DD/MM/RR HH24.MI.SSXFF'
'DD.MM.RR HH:MI:SSXFF PM'
'DD/MM/RR HH:MI:SSXFF PM'
'DD-MON-YYYY HH24:MI'
'DD-MON-YYYY HH24.MI.SSXFF'
'DD-MON-YYYY HH:MI:SSXFF PM'
'DD-MON-YYYY HH24:MI TZR'
'DD-MON-YYYY HH24.MI.SSXFF TZR'
'DD-MON-YYYY HH.MI.SSXFF PM TZR'
Automatically Supported Number Format Masks
'FML999G999G999G999G990D00'
'999G999G999G999G990D00'
'999G999G999G999G990D0000'
'999G999G999G999G999G999G990'
'999G999G999G999G990D00MI'
'S999G999G999G999G990D00'
'999G999G999G999G990D00PR'