Quire - Unable to perform Date operations on Date field after CSV export to excel

Status: To-do

The CSV export extracts date columns in "MMM DD, YYYY" and excel is unable to work with this format.

Created by Dinesh Kumar Jun 18, 2020

@dinesh.kumar - unfortunately, we weren't able to reproduce this issue on our side. The date format (see screenshot excel value bar) is MM/DD/YYYY.

Thus, we were able to create formulas.

Please note we have opened the CSV file with Excel in a specific way, not by double clicking on the CSV file. Please see this link on how to open CSV file in Excel safely: https://www.copytrans.net/support/how-to-open-a-csv-file-in-excel/

Peggy, Jun 19, 2020

inbuilt excel functions are unable to identify the format and so the value is being treated as plain old text.

Dinesh Kumar, Jun 18, 2020

The problem happens when I double click and open the file directly as mentioned. However if I import it into excel the problem does not happen. Thanks for the suggestion.

Dinesh Kumar, Jun 19, 2020