The file I’m using has only two fields, DATE1 and DATE2, both of which use the default *ISO format. From a STRSQL session:
insert into dates00
values (current date, ’2005-01-01′)
“current date” will supply just what it implies, in the proper format. The hardcoded date must be valid and match the format of the date field.
update dates00 set date1 = ’2004-01-31′