Page Comparison

...

1. d - The day of the month, from 1 to 31
2. dd - the day of the month from 01 to 31
3. M - the month from 1 to 12
4. MM - the month from 01 to 12
5. MMM - the abbreviated name of the month (Jan, Feb...)
6. MMMM - the full name of the month
7. yy - the year from 00 to 99
8. yyyy - the year as four digits
9. yyyyy - the year as five digits. E.G. 02021
10. / - the date separator
11. Any string not in the following list may be used as a date separator
    1.  d,dd,ddd,dddd,f,ff,fff,ffff,fffff,ffffff,fffffff,F,FF,FFF,FFFF,FFFFF,FFFFFF,FFFFFFF,g,gg,h,hh,H,HH,K,m,mm,M,MM,MMM,MMMM,s,ss,t,tt,y,yy,yyy,yyyy,yyyyy,z,zz,zzz,:,/,%

Invisible Fields

Image Added

Invisible fields allow fields to be set on the format that are not present in the import file. 

Using the image above as an example, the import CSV file will not contain a Workgroup column. When the file is imported, a Workgroup column will be added, all rows will be set to the Invisible Value (PAY001)

Defined Columns

FAQ