Date format issue in excel report

Certified Lead Developer
We are using "Export SQL to Excel" smart service from "Excel Tools" plugin to create an excel report. Even though we have set a column to date format (column data type is date as well, database is Oracle) in the excel template, the generated excel does not retain the date format. Is there a way to force excel recognize the cell values as date for a column?

OriginalPostID-251711

  Discussion posts and replies are publicly visible

Parents Reply Children
  • 0
    Appian Employee
    in reply to sanikat

    Keep in mind that Appian has a date type, so as long as you use that type you should be able to insert the data fine using a write to data store entity. If I misunderstood, please provide a lot more information about what you're trying to do (e.g. how are you inserting the data, what error messages have you seen, etc.).

    Also I'd strongly suggest creating a new post - this thread is 5 years old and is not related to your question.