I did it as below:
My data as below:
Both CreateDate and DeliveryDate is in Date-time format.
I have already provide my data set....
use these formula,forget the previous one:
It works fine on my Qvd file 🙂
Hope your case like the following
if the date is like the following and the field name is orderdate
first make ur Qlik understand that its a date and time so set the format to make Qlik understand that
Date#(orderdate,'MMDDYYYYHHMMSS') which will be read by Qlik as below
now convert that to original /general format for that
then the result should be 05/19/2018 10:12:36
Hope this helps
I haven't asked to you for data set.
I asked SAI. And yes one more thing, how are you using Date# function without knowing the input format in the question? May be his format is different!