Skip to main content
Past/Invalid Date Processing

How to automatically change Past and Invalid Task Dates to a Current or Future Date during the CSV Import

eLogii avatar
Written by eLogii
Updated over 2 years ago

If your Tasks CSV Import contains Tasks with Past and/or Invalid Dates, you can automatically change the Date for these Tasks to a Current or Future Date during the Import.

Navigate to Configuration β‡’ Task CSV Import β‡’ CSV Processing, and Enable 'Show date processing options' for this feature to appear on the Task CSV Import panel. You can then choose to Enable during each Import and change the Date as required.

If you would like this feature to be Enabled at all times during the Task CSV Import, then Enable the second option as well: 'Before importing, change past dates in the CSV'.

Click Save once you have selected your preferences.

In addition, it is also possible to enable an automatic date format conversion, as well as setting an automatic date range interval to a specified number of days, as seen in the screenshot above.

Once the feature has been enabled, go to Tasks β‡’ Import. This will take you to the import screen where the option 'Before importing, change past and non-existing dates in the CSV' will be shown as pictured below.

Did this answer your question?