Import App: How should I format a date

  • Profile Image
    Asked on July 20, 2016 at 10:09 PM
  • Profile Image
    Answered on July 20, 2016 at 11:19 PM

    Hello yourhuntingapp,

    You can format a date on how you think it is convenient for you. Do you have a specific concern or purpose for this?

    Looking forward to your response.

  • Profile Image
    Answered on July 21, 2016 at 10:45 AM
    I am importing my data from an excel file. I have modified the cell format to be a date and when I import the data it just shows up as numbers. It does not keep the date format.
    Clint McDonald
  • Profile Image
    Answered on July 21, 2016 at 12:13 PM

    You should right click on the cell you want to format then click on the option "Format Cells", you should get a window like the one below, there you should select "Text" and click OK: 

    Then in your Excel file you should add the date with these two different formats: 

    1. 07-21-2016

    2. 2016-12-12

    This should be the result: 

    Hope this helps.