I am trying to import a .csv file with a due date column and then reassign it to the due date on the task itself in Asana. I am able to import all data and reassign a column to use as a section but the option to use an imported column as a due date is gray and unavailable. It says it needs to be in date format. I have tried several different date formats and each time the option still not available. HELP!
Hi @hellosaraflowers! Welcome to the Forum!
Sorry to hear you are running into this issue. To be able to import Due Dates with CSV importer, you need to use the standard US date format of month/day/year.
You can read more about the CSV Importer in the following Guide article: https://asana.com/guide/help/api/csv-importer
I hope this helps you resolve the issue but if it doesn’t, just let me know here and I’ll be more than happy to assist you further! Looking forward to your reply!
I am using the correct date format but am not sure if I had the correct header. I will revisit. Thanks-