When using the Import Files program to import data into GovCollect, it is important that dates be in the proper format in a CSV file to be imported.

Dates are always expected to be in the form YYYYMMDD coming in on a csv file.


How do you fix that.


1.  If you want to insert today's date into a date field the Literal is: ||dtos(date())


2.  If you want to fix an incoming date as MM/DD/YYYY the Literal is ||dtos(ctod("||CC||"))


the || means this is a dbase command to follow.

the ||CC|| means insert the data here.


so in number two dtos(ctod("mm/dd/yy"))  dtos is date to string in the yyyymmdd format and ctod is character to date