1 Reply Latest reply: May 26, 2017 4:29 PM by Laurelly Allaway RSS

    Date Field does not import as a date in data manager

    Casey McDonald

      I am currently connecting to an Oracle Database for my data. I have a table called SD_WR and two different date fields named "DATE_REQUESTED" and "DATE_COMPLETED." Both are defined as "Date/Time" in Access and are both formatted as "mm/dd/yyyy"

       

      However, when I load the data in Qlik, it identifies "DATE_COMPLETED" as a valid date, but designates "DATE_REQUESTED" as general within the data manager. Whenever I attempt to change it to date within the data manager, it deletes out all values within the field.

       

      Any ideas as to what could be causing this?