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