Hi All,

On our on premise Qlik Sense, in a raw extract, our date fields are numeric i.e. 42020. This could easily be converted to a date field using the Date() function.

I am currently migrating to SaaS and using the Qlik 'Direct Access Data Gateway'. I notice that all date fields are no longer shown as numbers, but as DateTime, with the Time always being 12:00:00 AM. So for example 3/28/2018 12:00:00 AM. This means that I can no longer use the Date() function, but I am forced to change it to

Date(Floor(TimeStamp#(BSDATCRE,'MM/DD/YYYY hh:mm:ss TT')), 'DD/ MM/YYYY')

Is this normal behavior in the SaaS or can I disable this unwanted conversion from Number to DataTime?