If you find after upgrading to 11.7.1 that your date formats in appscript or modscript suddenly switch from your selected locale to one of the English varieties this is an unintended consequence of a change to resolve other locale issues. A fix will be available in a later release. For specific instructions on how to work around this, contact Support
This is the important part, we can convert Variants that represent Date/Time values to a floating point using CDbl, then subtract one from the other to get difference. The value will represent integer days and fractions of a day. You can use Abs( ... ) to get the absolute value if you do not care which value is bigger.
Add a pre-import modscript to existing Database Import Option Set. The script should set the two fields to their default values, like this:Shell.Item().SetFieldValue("SUBMITDATE", "Auto" );
If you are using 11.3+ then you work around this problem by using ModScript , which can issue SQL commands. You could write an SQL command to update the TS_ADDDATE and TS_LASTUPDATEDATE columns in the database after adding these records.
