Use the Date#() and Date() functions to make sure what you display on Qlik or load using the script is always going to have a consistent timestamp.
E.g.: LOAD *, Date#(Date(Field, 'DD/MM/YYYY hh:mm'), 'DD-MM-YYYY hh:mm:ss') AS FormattedDate FROM ...; The first date mask is the "output" format you want it into, in this case, Spanish: DD/MM/YYYY and without seconds. The second date mask is the "input" format from the field, in this case DD-MM-YYYY and with seconds.
.png "Miguel_Angel_Baeyens"){kind=avatar}
