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